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-01970: You must specify a database name for CREATE CONTROLFILE

1 Answers  


ORA-06601: LU6.2 Driver: Invalid database ID string

1 Answers  


ORA-01218: logfile member is not from the same point-in-time

1 Answers  


ORA-24807: LOB form mismatch

1 Answers  


ORA-09941: Version of orapasswd or installer is older than file.

1 Answers  


ORA-30122: value 'string' for 'string' must be between 'number' and 'number'

1 Answers  


TNS-04084: WARNING: Non-reloadable parameters have retained their values.

1 Answers  


ORA-09213: slgfn: error fabricating file name

1 Answers  


PLS-00323: subprogram or cursor 'string' is declared in a package specification and must be defined in the package body

1 Answers  


ORA-31055: A null XMLType element cannot be inserted into RESOURCE_VIEW

1 Answers  


PLS-00524: The parameter type in an ORDER method must be the containing object type.

1 Answers  


ORA-12521: TNS:listener does not currently know of instance requested in connect descriptor

1 Answers  


Categories