PCC-00118: Use of host variable initialization not supported
by ANSI SQL



PCC-00118: Use of host variable initialization not supported by ANSI SQL..

Answer / guest

Cause: An Oracle extension to the ANSI/ISO SQL standard was
used. Specifically, a host variable was initialized in its
declaration, as shown in the following Pro*C example: EXEC
SQL BEGIN DECLARE SECTION; int dept_number = 20; -- not
ANSI/ISO-compliant EXEC SQL END DECLARE SECTION; This
informational message is issued by the FIPS Flagger when
FIPS=YES.

Action: No action required. However, for ANSI/ISO
compliance, do not initialize host variables in their
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-12832: Could not allocate slaves on all specified instances

1 Answers  


ORA-30335: JOIN KEY clause references a level not in this hierarchy

1 Answers  


TNS-02515: Encryption/crypto-checksumming: unknown control type

1 Answers  


ORA-31161: element or attribute "string" cannot be stored out of line

1 Answers  


DRG-50908: invalid maximum number of documents string

1 Answers  






KUP-04062: no data source specified

1 Answers  


RMAN-03001: recovery manager command sequencer component initialization failed

1 Answers  


DRG-13001: sub lexer and multi lexer must have the same owner

1 Answers  


RMAN-06094: datafile string must be restored

1 Answers  


RMAN-01006: error signalled during parse

1 Answers  


ORA-07279: spcre: semget error, unable to get first semaphore set.

1 Answers  


DRG-50926: invalid text query string

1 Answers  


Categories