Follow Our FB Page << CircleMedia.in >> for Daily Laughter. We Post Funny, Viral, Comedy Videos, Memes, Vines...


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-08099: specifying standby controlfile for proxy backup

1 Answers  


PCB-00580: Previous use of host variable "string" uses different indicator

1 Answers  


TNS-12566: TNS:protocol error

1 Answers  


ORA-13008: the specified date format has an invalid component

1 Answers  


RMAN-08015: datafile string switched to datafile copy

1 Answers  






IMP-00008: unrecognized statement in the export file: string

1 Answers  


ORA-12334: database (link name string) is still open

1 Answers  


ORA-25258: cannot register for notifications on an 8.0 style exception queue

1 Answers  


ORA-02330: datatype specification not allowed

1 Answers  


ORA-04010: the number of values to CACHE must be greater than 1

1 Answers  


ORA-36638: (XSDUNION17) Concat dimension workspace object cannot be changed to UNIQUE because it has a non-unique concat base dimension workspace object.

1 Answers  


SQL*Loader-00415: column string in table string cannot use and be the object of an SDF or LOBFILE

1 Answers  






Categories