我试图运行这个存储过程
DECLARE
P_TICKER_SERIAL VARCHAR2(200);
P_SECTOR_CODE VARCHAR2(200);
P_SOURCE_ID VARCHAR2(200);
P_COUNTRY_CODE VARCHAR2(200);
P_FILTER_TYPE NUMBER;
CUR_OUT SYS_REFCURSOR;
dbUserTable DBUSER%ROWTYPE;
BEGIN
P_TICKER_SERIAL :='14232';
P_SECTOR_CODE := '15';
P_SOURCE_ID := 'TDWL';
P_COUNTRY_CODE := 'SA';
P_FILTER_TYPE := 1;
PKG_name.GET_user(
P_TICKER_SERIAL => P_TICKER_SERIAL,P_SECTOR_CODE => P_SECTOR_CODE,P_SOURCE_ID => P_SOURCE_ID,P_COUNTRY_CODE => P_COUNTRY_CODE,P_FILTER_TYPE => P_FILTER_TYPE,CUR_OUT => CUR_OUT
);
open CUR_OUT;
LOOP
FETCH CUR_OUT INTO dbUserTable;
dbms_output.put_line(dbUserTable.email);
END LOOP;
CLOSE CUR_OUT;
END;
/
但它给我这个错误
Error report: ORA-06550: line 8,column 15: PLS-00201: identifier 'DBUSER' must be declared ORA-06550: line 8,column 15: PL/sql: Item ignored ORA-06550: line 24,column 2: PLS-00382: expression is of wrong type ORA-06550: line 24,column 2: PL/sql: sql Statement ignored ORA-06550: line 26,column 24: PLS-00320: the declaration of the type of this expression is incomplete or malformed ORA-06550: line 26,column 5: PL/sql: sql Statement ignored ORA-06550: line 27,column 28: PLS-00320: the declaration of the type of this expression is incomplete or malformed ORA-06550: line 27,column 7: PL/sql: Statement ignored 06550. 00000 - "line %s,column %s:\n%s" *Cause: Usually a PL/sql compilation error. *Action:
有谁知道有什么问题？
谢谢。
尝试执行这样的过程，
原文链接：/oracle/205997.htmlvar c refcursor;
execute pkg_name.get_user('14232','15','TDWL','SA',1,:c);
print c;
