When trying to create a test definition against SYS.UTL_FILE QCTO, it fails with the following:
ORA-01403: no data found
ORA-06512: at QCTO.QU_UNIT_TEST_XP, line 1558
----- PL/SQL Call Stack -----
object line object
handle number name
24E59EC8 1479 package body QCTO.QU_RUNTIME
24E59EC8 1909 package body QCTO.QU_RUNTIME
24E59EC8 2103 package body QCTO.QU_RUNTIME
24DA01C0 1582 package body QCTO.QU_UNIT_TEST_XP
24DA01C0 1687 package body QCTO.QU_UNIT_TEST_XP
24DA01C0 1820 package body QCTO.QU_UNIT_TEST_XP
24E3BA68 1400 package body QCTO.QU_HARNESS_XP
24DDA840 4 anonymous block
Unable to lookup the base datatype in ALL_ARGUMENTS for this parameter.
ARGUMENT_NAME = FILE1
OVERLOAD =
POSITION = 1
PROGRAM_NAME = IS_OPEN
UNIT_TEST_GUID =
It seems that the parsing becomes incorrect as the parameter to SYS.UTL_FILE.IS_OPEN is called FILE, not FILE1.
RESOLUTION:
Issue resolved in Quest Code Tester for Oracle version 1.9.1. Install the new Quest Code Tester and upgrade the backend repository.
