I tried to create a test case with cursor as input parameter, It is throwing error. Also we are facing issues with test case where we have overloaded procedure and multidimensional array, Can some one please help. here.
No help is possible until you actually tell us what the error and issues are.
1. WHAT you are doing
2. HOW you are doing it
3. WHAT results you are getting
Also post any code needed to try to reproduce the problem
I created above test case on below a procedure , But in result it is showing error "Expected exception: [NONE], Received: [900: ORA-00900: invalid SQL statement ORA-06512: at line 4 ]"
CREATE OR REPLACE procedure APPS.pr_emp_1(p_in IN SYS_REFCURSOR, p_count out number) as
fetch p_in into l_sal;
l_total_sal := l_total_sal + l_sal;
exit when p_in%notfound;
p_count := l_total_sal;