2 Replies Latest reply on May 31, 2016 6:49 AM by 3248143

    SQL Developer Test Case issue issues

    3248143

      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.

        • 1. Re: SQL Developer Test Case issue issues

          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.

           

          SHOW US

           

          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

          • 2. Re: SQL Developer Test Case issue issues
            3248143

            abc.bmp

            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

            l_sal number:=0;

            l_total_sal number:=0;

            begin

              loop

              fetch p_in into l_sal;

              l_total_sal := l_total_sal + l_sal;

              exit when p_in%notfound;

            end loop;

            close p_in;

            p_count := l_total_sal;

            end;