Re: Seeing results of stored procedure

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

Originally posted by Harry Boswell
> 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

--
All you need in this life is ignorance and confidence, and then success is sure. -- Mark Twain (1835 - 1910)


Posted via http://dbforums.com