'BINARY_DOUBLE' or BINARY_FLOAT' must be declared (4323808)

When running a test against a package or function, this error shows:

PLS-00201: Identifier 'BINARY_DOUBLE' must be declared

PL/SQL: Item ignored

PLS-00201: Identifier 'BINARY_FLOAT' must be declared

PL/SQL: Item ignored

WORKAROUND

1. Copy QU_TEMPLATE_XP.PKB and QU_XMLDOM_IMPORT92.PKB files into Code subfolder of the folder where Code Tester executable was installed (the existing file QU_TEMPLATE_XP.PKB will be replaced).

By default the “code” sub folder executable is in here:

C:\Program Files (x86)\Quest Software\Quest Code Tester for Oracle\Code

2. Close Code Tester.

3. Connect Toad to schema where Code Tester repository is installed and compile QU_TEMPLATE_XP.PKB and QU_XMLDOM_IMPORT92.PKB package bodies.

4. For schema from step 3, open and run QU_INSTALL_TEMPLATES.SQL from the Code subfolder in Toad.

5. Connect Code Tester to tested schema and regenerate testing packages. BINARY_DOUBLE and BINARY_FLOAT should disappear.

STATUS

Waiting for fix in a future release of Quest Code Tester for Oracle