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-31509: publication does not exist

1 Answers  


ORA-39961: message specified was not found

1 Answers  


SQL*Loader-00292: ROWS parameter ignored when a LOB column is loaded

1 Answers  


ORA-07756: slemcf: fread failure

1 Answers  


ORA-16767: Logical apply service unexpectedly online

1 Answers  






PLS-00670: sort columns must be simple column names

1 Answers  


DRG-11832: Request Entity Too Large

1 Answers  


RMAN-04031: initialization parameters used for automatic instance: string

1 Answers  


PCC-02201: Found syntax error

1 Answers  


ORA-38743: Time/SCN is in the future of the database.

1 Answers  


ORA-03132: two-task default value overflow

1 Answers  


ORA-01091: failure during startup force

1 Answers  


Categories