如何在oracle sql开发人员中运行存储过程？

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:

有谁知道有什么问题？
谢谢。

var c refcursor;
execute pkg_name.get_user('14232','15','TDWL','SA',1,:c);
print c;

（编辑：李大同）

【声明】本站内容均来自网络，其相关言论仅代表作者个人观点，不代表本站立场。若无意侵犯到您的权利，请及时与联系站长删除相关内容!