PCC-00118: Use of host variable initialization not supported
by ANSI SQL
- 1 Answers
- 2624 Views
- I also Faced
- E-Mail Answers
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 |
RMAN-08099: specifying standby controlfile for proxy backup
PCB-00580: Previous use of host variable "string" uses different indicator
TNS-12566: TNS:protocol error
ORA-13008: the specified date format has an invalid component
RMAN-08015: datafile string switched to datafile copy
IMP-00008: unrecognized statement in the export file: string
ORA-12334: database (link name string) is still open
ORA-25258: cannot register for notifications on an 8.0 style exception queue
ORA-02330: datatype specification not allowed
ORA-04010: the number of values to CACHE must be greater than 1
ORA-36638: (XSDUNION17) Concat dimension workspace object cannot be changed to UNIQUE because it has a non-unique concat base dimension workspace object.
SQL*Loader-00415: column string in table string cannot use and be the object of an SDF or LOBFILE
Oracle Errors 
