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-27453: %s is an invalid job or program argument name.

1 Answers  


NNC-00417: name "string" already exists

1 Answers  


LPX-00602: Invalid child element '~1S' of element '~2S'.

1 Answers  


IMP-00088: Problem importing metadata for index string. Index creation will be skipped

1 Answers  


RMAN-06107: WARNING: controlfile is not current for REPORT NEED BACKUP DAYS

1 Answers  


ORA-17510: Attempt to do i/o beyond file size

1 Answers  


ORA-24786: separated transaction has been completed

1 Answers  


ORA-25409: failover happened during the network operation,cannot continue

1 Answers  


ORA-16711: the resource guard index is out of bounds

1 Answers  


ORA-01698: a clone database may only have SYSTEM rollback segment online

1 Answers  


NZE-29038: There are no matching certificates.

1 Answers  


NNL-00919: Time until server shutdown: string

1 Answers  


Categories