hmm how do i call a stored procedure with 3 params, 1 of them optional
call proc('1','2') fails
or optionally, how do i query for the definition of the stored procedure to get details
this stored procedure has 3 params, varchar,varchar and sys_refcursor, and it returns a sys_refcursor
how do i call it to get the row results in plain sql?
call theprocedure(varchar2(param1),varchar(param2), null) does nothing, says wrong param types