Please help! Error PLS-00323 trying to enter call specs for java stored procedures

Hi,

I am trying to enter these call specs for java stored procedures returning a cursor:

CREATE OR REPLACE PACKAGE cursor_pkg AS
TYPE cursorType IS REF CURSOR;
PROCEDURE get_order_hdrs (orderId NUMBER, rset out cursor_pkg.cursorType);
PROCEDURE get_order_hdrs_by_type (orderType VARCHAR2, rset in out cursor_pkg.cursorType);
end cursor_pkg;
/

... This goes fine.

and then:

CREATE OR REPLACE PACKAGE BODY cursor_pkg AS PROCEDURE get_order_hdrs (orderId NUMBER, rset cursor_pkg.cursorType) AS
LANGUAGE JAVA
NAME 'JStoredProc0004.getOrderHdrs (java.lang.Long, java.sql.ResultSet)';
PROCEDURE get_order_hdrs_by_type (orderType VARCHAR2, rset cursor_pkg.cursorType) AS
LANGUAGE JAVA
NAME 'JStoredProc0004.getOrderHdrsByType(java.lang.String, java.sql.ResultSet)';
end cursor_pkg;
/

... this returns:

PLS-00323 subprogram or cursor 'string' is declared in a package specification and must be defined in the package body

If I try "rset out cursor_pkg.cursorType" instead of "rset cursor_pkg.cursorType" in the CREATE ... BODY part I get in addition to PLS-00323 :

PLS-00235 the external type is not appropriate for the parameter

I cannot see what goes wrong here, could anyone please have a look?

Thanks a lot! Received on Thu Mar 06 2003 - 11:24:09 CST