Re: HELP:How to execute a stored procedure in sqlplus???

To execute a stored procedure from sql:
SQL> execute procedure_name
or to execute aa package procedure

SQL> execute package_name.procedure_name

Michael Powers
President
Michael Powers & Associates
Oracle Consultants

violin wrote:

> Hello, I need some help!!
> 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 Sun May 31 1998 - 16:09:41 CEST