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 Jun 6, 2017 1:59 PM

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

1. Re: "Invalid Column Index" when adding a Process Validation to a Unit Test

thatJeffSmith-Oracle Jun 6, 2017 4:15 PM (in response to Andrew Tulley)

don't you need

begin
null;
end;
Like Show 0 Likes(0)

Actions
2. Re: "Invalid Column Index" when adding a Process Validation to a Unit Test

Andrew Tulley Jun 7, 2017 9:05 AM (in response to thatJeffSmith-Oracle)

Hi Jeff,

Thanks for your reply.

I have now tried what you suggest and receive the same error ("Invalid column index").

I have also tried using the default text that SQL Developer puts into the validation, i.e.:

-- Please raise an exception if the validation fails.
-- For example:
DECLARE
    l_count NUMBER;
    wrong_count EXCEPTION;
BEGIN
    SELECT count(*) INTO l_count FROM dual;
    IF l_count = 0
    THEN
        RAISE wrong_count;
    END IF;
END;

Using this I also receive the same error ("Invalid column index").

Interestingly, running the same unit test using SQL Developer 4.0.3.16 works. Some problem specific to the latest version of SQL Developer therefore perhaps?

Any other thoughts very gratefully received!

Thanks
Andy
Like Show 0 Likes(0)

Actions
3. Re: "Invalid Column Index" when adding a Process Validation to a Unit Test

thatJeffSmith-Oracle Jun 7, 2017 12:06 PM (in response to Andrew Tulley)

Perhaps. I'd open an SR with MOS.
Like Show 0 Likes(0)

Actions
4. Re: "Invalid Column Index" when adding a Process Validation to a Unit Test

Andrew Tulley Jun 8, 2017 9:22 AM (in response to Andrew Tulley)

For anyone finding this thread, this is confirmed by Oracle Support as a bug. No resolution exists as at 8-Jun-2017.

Bug 25973908 : UT: USING 'USER PL/SQL CODE' IN 'PROCESS VALIDATION' FAILS: INVALID COLUMN INDEX
Like Show 1 Likes(1)

Actions

Go to original post