PCC-02362: Host variable not declared within SQL DECLARE section



PCC-02362: Host variable not declared within SQL DECLARE section..

Answer / guest

Cause: When MODE=ANSI is specified at precompile time, all
host variables must be declared inside Declare Sections.
Remember that MODE=ANSI refers to ANSI SQL, not ANSI C.

Action: Add the EXEC SQL BEGIN DECLARE SECTION... EXEC SQL
END DECLARE SECTION statements around all host variable
declarations.

Please add more information about this Error

Is This Answer Correct ?    0 Yes 0 No

Post New Answer

More Oracle Errors Interview Questions

ORA-07571: szrfc: $FIND_HELD failure

1 Answers  


ORA-29300: ORACLE error, tablespace point-in-time recovery

1 Answers  


ORA-28550: pass-through SQL: cursor not found

1 Answers  


ORA-32020: SID=* clause needed to modify this parameter

1 Answers  


NNO-00701: warning: cannot construct checkpoint file name, checkpointing disabled

1 Answers  






PCC-02343: body of cursor must be a query expression

1 Answers  


ORA-00408: parameter string is set to TRUE

1 Answers  


ORA-22891: cannot have multiple columns in REF constraint

1 Answers  


RMAN-06101: no channel to restore a backup or copy of the controlfile

1 Answers  


ORA-02062: distributed recovery received DBID string, expected string

1 Answers  


ORA-39035: Data filter string has already been specified.

1 Answers  


IMP-00057: Warning: Dump file may not contain data of all partitions of this table

1 Answers  


Categories