This is the syntax I used to execute a procedure. I am using SQL devoloper
variable r refcursor;
variable v VARCHAR2(100);
exec P_GET_ATRB_DTL1(‘1223~24314~314’)
There is 1 IN parameters and 3 OUT parameters of which one is of type sysrefcursor(OUT parameter).Is there any error in the syntax.
When I am executing the procedure SQL devoloper is giving the
error code
ORA-00900: invalid SQL statement
