4 Replies Latest reply on Jun 8, 2017 9:22 AM by Andrew Tulley

    "Invalid Column Index" when adding a Process Validation to a Unit Test

    Andrew Tulley

      SQL Developer 4.2.0.17.089 on Mac OS X Sierra

      Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit

       

      Problem summary

       

      "Invalid Column Index" error received when running Unit Tests in SQL Developer

       

      Problem Detail

       

      I have the world's simplest procedure:

       

      CREATE OR REPLACE PROCEDURE fooproc (
          p_dummy IN number
      )
      
      IS
         
      BEGIN
      
          NULL;
      
      END fooproc;
      /
      

       

       

      I have created a very simple Unit Test in SQL Developer to test this function.:

      * No startup process

      * No teardown process

      * I have unticked the "check result" checkbox

      * I have set Expected Result to SUCCESS

       

      This all works fine. I can run the Unit Test and it succeeds as you would expect.

       

      However, if I now add a Process Validation of type User PL/Sql Code and specify its content simply as:

       

      NULL;
      

       

       

      If I now run the Test the User Validation portion fails with an error:

       

      Validation #1 - Private (User PL/Sql code)     ERROR    Validation User PL/Sql code failed: Invalid column index

       

       

      This problem is causing the vast majority of my existing Unit Tests to fail with an Invalid Column Index error.

       

       

      Any help greatly appreciated!

       

      Andy