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