HELP:How to execute a stored procedure in sqlplus???
From: violin <violin_at_ms1.accmail.com.tw>
Date: Wed, 27 May 1998 09:04:26 GMT
Message-ID: <356bd4ea.30251283_at_192.9.10.33>
Hello, I need some help!!
[Quoted] I have created a stored procedure on Oracle 7.2, and then I logon sqlplus scott/tiger,
Date: Wed, 27 May 1998 09:04:26 GMT
Message-ID: <356bd4ea.30251283_at_192.9.10.33>
Hello, I need some help!!
[Quoted] I have created a stored procedure on Oracle 7.2, and then I logon sqlplus scott/tiger,
But how to execute the procedure in SQL>
My procedure is (been created already):
CREATE OR REPLACE PROCEDURE TEST(CUR IN OUT CUR_RETURN.ATTN_CUR)
IS
BEGIN
OPEN CUR FOR SELECT * FROM EMP;
END;
CREATE OR REPLACE PACKAGE CUR_RETURN IS
TYPE ATTN_CUR IS REF CURSOR RETURN SCOTT.EMP%ROWTYPE;
END;
Could anyone help me? Thank you so much!
please Cc to : violin_at_ms1.accmail.com.tw
Received on Wed May 27 1998 - 11:04:26 CEST