0 Replies Latest reply on Nov 18, 2013 10:44 AM by 1009704

    sql developer unit test case framework

    1009704

      Hi All,

       

      We am trying out a simple procedure with a ref cursor as an out parameter. I have given the procedure and the error below.

      Please help us as we are new to this framework.

       

      Procedure :

       

      create or replace

      procedure test_ut (pout out sys_refcursor)

      as

      begin

      open pout for

      select 100 col1, 200 col2 from dual union all select 1000 col1, 2000 col2 from dual

      end;

      /

       

      Dynamic query :

       

      SELECT 1 as PIN,

      (CURSOR(SELECT 1 num_value,'The input value is 1' char_value FROM DUAL)) as POUT$

      from dual;

       

      Below is the error  :

       

      TEST_UT 

      GSX_UNIT_TEST_REPO: Run On - 2013-11-18 14:58:37.131131    ERROR    814.0    TEST_UT failed: Expected exception: [NONE], Received: [6550: ORA-06550: line 2, column 3:

      PLS-00201: identifier 'GREP_OWNER.TEST_UT' must be declared

      ORA-06550: line 2, column 3:

      PL/SQL: Statement ignored

      ]

      Implementation - Test Implementation 1    ERROR    814.0    Expected exception: [NONE], Received: [6550: ORA-06550: line 2, column 3:

      PLS-00201: identifier 'GREP_OWNER.TEST_UT' must be declared

      ORA-06550: line 2, column 3:

      PL/SQL: Statement ignored

      ]

      Operation Call    ERROR    814.0    Expected exception: [NONE], Received: [6550: ORA-06550: line 2, column 3:

      PLS-00201: identifier 'GREP_OWNER.TEST_UT' must be declared

      ORA-06550: line 2, column 3:

      PL/SQL: Statement ignored

      ]

      IN Parameter #1 - PIN  Value: [1]

      OUT Parameter #2 - POUT

       

      Thanks in advance