Skip to Main Content

SQL Developer

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

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

Andrew TulleyJun 6 2017 — edited Jun 8 2017

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

Comments

Locked Post
New comments cannot be posted to this locked post.

Post Details

Locked on Jul 6 2017
Added on Jun 6 2017
4 comments
186 views