PCC-02362: Host variable not declared within SQL DECLARE section
- 1 Answers
- 6908 Views
- I also Faced
- E-Mail Answers
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 |
LPX-00213: comment did not end in "-->"
NNL-00809: Queries received, multiple types: number
ORA-22952: Nested Table equality requires a map method on the element ADT
ORA-30744: "string" is not an object table
ORA-34359: (MXDSS11) string appears twice in the alias list.
ORA-28550: pass-through SQL: cursor not found
TNS-01071: %s is set to string
TNS-00297: Logging Level : string
ORA-37127: (XSCCOMP02) The COMPRESSED COMPOSITE workspace object must be last in the dimension list.
ORA-01880: the fractional seconds must be between 0 and 999999999
IMG-00552: invalid inputChannels specified
ORA-31516: CDC change set string already exists
Oracle Errors 
