I am calling an insert procedure through Microsoft Lightswitch app, and I get this error:
ORA-06550: line 29, column 8:
PLS-00103: Encountered the symbol "SP_MUSIC_INS" when expecting the following:
The procedure is an oracle procedure returning a sys_refcursor. It has been mapped through DEVART entity framework 4 to work with Lightswitch app as a RIA service.
To test the oracle procedure works, I am trying to run it from oracle. When I walk through Debug everything is good and the refcursor parameter indicates 1iteration. (Can't see vaule due to it being a refcursor.)
What did I do wrong? How do I get it to run correctly in Toad? How do you test a sys_refcursor in SQLPLUS? Did I miss something in a refcursor setup step in TOAD and in Entity Framework causing this error?
Here is the script I am executing in Toad for the refcursor but I get an the error an not the ability to define the ref_CURSOR AS A CURSOR.
p_Music_GENRE_DESC := 'Test\Proc Test';
p_SERIES_IND := 'N';
-- p_Music_GENRE_CODE_RC := null;
exec SP_MUSIC_INS (p_Music_GENRE_DESC,p_SERIES_IND,:p_Music_GENRE_CODE_RC);
Here is how I am calling and assigning the sys_refcursor output.
RETURNING Music_CODE into p_Music_GENRE_SEQ;
open p_Music_GENRE_CODE_RC for select p_Music_GENRE_SEQ as p_Music_GENRE_SEQ from dual;