CURSOR S_YS(table_name varchar2,P_HH VARCHAR2,P_YDNY VARCHAR2) IS SELECT YSDF FROM table_name WHERE YDNY=P_YDNY AND HH=P_HH;不能这么写要用表名作参数,得用连接的sql语句来写sqlstr varchar2(2000); sqlstr:='CURSOR S_YS('||table_name||'varchar2,'||P_HH||' VARCHAR2,'||P_YDNY|| 'VARCHAR2) IS SELECT YSDF FROM '||table_name||' WHERE YDNY='||P_YDNY||' AND HH='||P_HH; execute immediate sqlstr
sqlstr:='CURSOR S_YS('||table_name||'varchar2,'||P_HH||' VARCHAR2,'||P_YDNY|| 'VARCHAR2) IS SELECT YSDF FROM '||table_name||' WHERE YDNY='||P_YDNY||' AND HH='||P_HH;
execute immediate sqlstr