Re: Seeing results of stored procedure

From: Harry Boswell <hboswel1_at_bellsouth.net>
Date: Tue, 14 Jan 2003 16:12:01 -0600
Message-ID: <pl292v8mhla5l1p3iqgpfenjb1jlm0rgu9@4ax.com>

On Fri, 03 Jan 2003 16:45:36 +0000, rajXesh <member11038_at_dbforums.com> wrote:

>
>Add a : at the start of the name of trhe cursor when you call the proc
>for eg
>SQL> exec Get_Facility.Get_Facility_By_ID(2290, :facility_out_cur);
>
>-- rajXesh

OK, I did that, and now I get:

SQL> variable facility_out_cur REFCURSOR; SQL> exec Get_Facility.Get_Facility_By_ID(2290,:facility_out_cur);

PL/SQL procedure successfully completed.

SQL> print :facility_out_cur;
ERROR:
ORA-24338: statement handle not executed

SP2-0625: Error printing variable "facility_out_cur"

What's this telling me?

Thanks,
Harry Boswell Received on Tue Jan 14 2003 - 16:12:01 CST