Seeing results of stored procedure

From: Harry Boswell <hboswel1_at_bellsouth.net>
Date: Thu, 02 Jan 2003 16:24:15 -0600
Message-ID: <1qe91vohcajuqutvn5a85jjb6354t7qtr9@4ax.com>

I've written a stored procedure which uses a ref cursor as output. I want to be able to test the procedure and see the output in either SQL*Plus or TOAD. So I try to execute the procedure like this:

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

But I get:

ERROR at line 1:

ORA-06550: line 1, column 45:
PLS-00201: identifier 'FACILITY_OUT_CUR' must be declared
ORA-06550: line 1, column 7:

PL/SQL: Statement ignored

(FACILITY_OUT_CUR is the name of the output refcursor within the procedure).

What am I doing wrong?

Thanks,
Harry Boswell Received on Thu Jan 02 2003 - 16:24:15 CST