I need to write some tests scripts to test a stored procedure in Oracle that returns a reference cursor to the user.
create or replace procedure my_oracleProc (
results_cursor OUT sys_refcursor ,
p_remote_user IN VARCHAR2 ,
p_remote_address IN VARCHAR2 )
The Oracle documentation sucks, and doesn't help me figure out how to write a script to call my procedure and then test the return values of the results_cursor.
Any help would be greatly welcomed.