-
Title
Loading a procedure gave the error: "UNRECOGNIZED CONSTRUCT OR SYNTAX ERROR at LINE 1, COL 36, OF -
Description
When I tried to load a procedure for testing, I get an error similar to the following.
Formatter Plus v4.8.8
@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@
UNRECOGNIZED CONSTRUCT OR SYNTAX ERROR at LINE 1, COL 36, OFFSET 35 :
@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@
PROCEDURE LOOPPROC (inval 'NUMBER')
-----------------------------------^--------------
(S3653) Expecting: ANYDATA ANYDATASET ANYTYPE BFILE BINARY BINARY_DOUBLE BINARY_FLOAT BINARY_INTEGER BLOB BOOLEAN CHAR CHARACTER CLOB DATE DBURITYPE DEC DECIMAL DOUBLE EXCEPTION FLOAT HTTPURITYPE identifier IN INT INTEGER INTERVAL LONG MDSYS MLSLABEL NATIONAL NATURAL NATURALN NCHAR NCLOB NUMBER NUMERIC NVARCHAR2 ORDSYS OUT PLS_INTEGER POSITIVE POSITIVEN RAW REAL REF RINT RNUMBER ROWID SDO_GEOMETRY SIGNTYPE SMALLINT STRING SYS TIMESTAMP URIFACTORYTYPE URITYPE UROWID VARCHAR VARCHAR2 VARRAY VARYING XMLTYPE
--------------------------------------------------
IS
begin -
Cause
The procedure itself or some call in the procedure has an input parameter argument with single-quotes around it.
-
Resolution
WORKAROUND:
In the error, look for the argument Quest Code Tester is complaining about. In the above example, it is point to the following:
PROCEDURE LOOPPROC (inval 'NUMBER')
Then go into your code and remove the single-quotes from the argument. In this case it would be NUMBER.
STATUS:
Waiting for fix in a future release of Quest Code Tester for Oracle.