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

RMAN-06182: archive log larger than MAXSETSIZE: thread string seq string string

1 Answers  


DRG-11831: Precondition Failed

1 Answers  


IMG-00523: invalid process verb

1 Answers  


PCB-00203: Nested group item "string" not supported

1 Answers  


NNF-04008: Error writing outputfile

1 Answers  






ORA-06514: PL/SQL: The remote call cannot be handled by the server

1 Answers  


PCB-00625: An indicator variable is not required with this attribute

1 Answers  


ORA-39307: the operation is illegal without an initial clone

1 Answers  


ORA-32610: missing SINGLE REFERENCE or DIMENSION keyword in MODEL clause

1 Answers  


ORA-25189: illegal ALTER TABLE option for an index-organized table

1 Answers  


DRG-11106: user database session has terminated during this operation

1 Answers  


ORA-29847: cannot create a local domain index on a partitioned index-organized table

1 Answers  


Categories