Executing stored proc in Toad SQL Editor
I have a stored procedure that returns a result set using a REF_CURSOR output parameter. How do I execute the stored procedure using TOAD SQL Editor instead of SQL Plus? I tried clicking on the Package and clicking the yellow thunderbolt and inserting the input parameters, but it is having viewing the result set - ref_cursor. Any ideas?
Thanks in advance!
(based on TOAD 18.104.22.168)
When you are inserting parameters (the 'Set Parameters' dialogue) click the 'Options' button to access the 'Output Options' which lets you configure how ref cursors will be displayed. I pretty much just use the 'Load into grid from memory (strong and weak)' option.
I'm running TOAD 22.214.171.124 and I don't see the 'Load into grid from memory (strong and weak)' option. When I click the print DBMS output or the Create and Write to table option I get an error.
The procedure executes fine in SQL PLUS but I can't get it to execute using TOAD. I get the following error in the second declare statement below: Error: PLS-00320: the declaration of the type of this expression is incomplete or malformed
Everything is spelled correctly and so I'm not sure why I would be getting that error.. The UPK_GET_SALARY_AVAIL_WEEKS create statement is:
CREATE OR REPLACE PACKAGE UPK_GET_SALARY_AVAIL_WEEKS IS
TYPE ref_cursor IS REF CURSOR;
PROCEDURE USP_C_TMWKSL_GET_SAL_WEEKS_SEL ( I_EMP_NUM VARCHAR2,
I_EMP_ROLE VARCHAR2, SAL_WKS OUT ref_cursor );
I'm quite confused...
I suppose downloading an upgrade is out of the question?
Good question... probably is out of the question at the moment..
Click Here to Expand Forum to Full Width