PLS-00201: 必须说明标识

[tangxufeng]

下面是整个过程,请指教

SQL> CREATE OR REPLACE PACKAGE PKG_TEST
2 AS
3 TYPE myrctype IS REF CURSOR;
4
5 PROCEDURE getid (p_id NUMBER, p_rc OUT myrctype);
6 END pkg_test;
7 /

程序包已创建。

SQL> CREATE OR REPLACE PACKAGE BODY PKG_TEST AS
2 PROCEDURE getid (p_id NUMBER, p_rc OUT myrctype)
3 IS
4 sqlstr VARCHAR2(200);
5 BEGIN
6 sqlstr :='select userid,username,truename from users where userid=:w_id';
7 OPEN p_rc FOR sqlstr USING p_id;
8 END getid;
9 END pkg_test;
10 /

程序包主体已创建。

SQL> var results refcursor
SQL> exec getid(1,:results);
BEGIN getid(1,:results); END;

*
ERROR 位于第 1 行:
ORA-06550: 第 1 行, 第 7 列:
PLS-00201: 必须说明标识符 'GETID'
ORA-06550: 第 1 行, 第 7 列:
PL/SQL: Statement ignored

[vc555]

exec KG_TEST.getid(......