把语句 Cursor myCur is select prd_id from table_name where trunc(ZH_CHECK_DATE,'dd')=trunc(sysdate,'dd'); 改为 myCur sys_refcursor; v_sql varchar2(2000); begin里面写语句 v_sql := ‘select prd_id from ’||table_name||‘ where trunc(ZH_CHECK_DATE,'dd')=trunc(sysdate,'dd'); open myCur for v_sql;
Cursor myCur is select prd_id from table_name where trunc(ZH_CHECK_DATE,'dd')=trunc(sysdate,'dd');
改为
myCur sys_refcursor;
v_sql varchar2(2000);
begin里面写语句
v_sql := ‘select prd_id from ’||table_name||‘ where trunc(ZH_CHECK_DATE,'dd')=trunc(sysdate,'dd'); open myCur for v_sql;
真是对存储过程是一巧不通。
编译成功。