Oracle8 Error Messages Release 8.0.4 A58312-01 |
Library | Product | Contents | Index

## 00001-00603: Oracle Precompiler: Pro*COBOL Release 2 Messages

### 00001 - 00099: Command Line (options) Messages

##### PCB-00001: text

Cause: This is a generic error message from the command-line processor.

Action: Correct the indicated error.

##### PCB-00002: command line processor severe error

Cause: The command line processor encountered a severe error.

Action: After making sure that all the command-line options are specified correctly, call customer support with a full account of all the options and configuration files used.

##### PCB-00003: value of DBMS option invalid with given value of MODE option

Cause: When MODE={ANSI14 | ANSI13}, DBMS=V7 or V8 was specified, or when MODE=ANSI, DBMS=v6 was specified. These option settings are incompatible. Note that the DBMS option was not available before release 1.5 of the Oracle Precompilers.

Action: With DBMS=V7 or V8, instead of MODE={ANSI14 | ANSI13}, specify MODE={ANSI | ORACLE}. With DBMS=V6, instead of MODE=ANSI, specify MODE={ANSI14 | ANSI13 | ORACLE}, but MODE=ORACLE is recommended.

##### PCB-00004: UNSAFE_NULL=YES must be used with DBMS=V7 or V8 and MODE=ORACLE

Cause: The option UNSAFE_NULL=YES has been used with DBMS=V6 or DBMS=NATIVE (the default) or has been used with MODE=ANSI/ANSI14/ANSI13.

Action: Use DBMS=V7 or V8 and MODE=ORACLE (the default) when using UNSAFE_NULL=YES or do not use UNSAFE_NULL=YES.

##### PCB-00005: command line option MODE=ANSI required with option NLS_LOCAL=YES

Cause: The precompiler option NLS_LOCAL=YES was used without also specifying MODE=ANSI. The precompiler option MODE=ANSI must be specified if NLS_LOCAL=YES.

Action: Set the precompiler option MODE=ANSI in addition to NLS_LOCAL=YES or do not set NLS_LOCAL=YES.

##### PCB-00006: USERID only used when SQLCHECK=FULL, userid ignored

Cause: The USERID option was specified when SQLCHECK={SYNTAX | NONE}. This is unnecessary.

Action: Specify the USERID option only when SQLCHECK=SEMANTICS.

##### PCB-00007: text

Cause: This is a generic error message from the command-line processor.

Action: Correct the indicated error.

##### PCB-00008: must use option SQLCHECK=SEMANTICS(FULL) when there is embedded PL/SQL

Cause: The precompiler tried to parse an embedded PL/SQL block when SQLCHECK={SYNTAX | NONE}. PL/SQL blocks can be parsed only when SQLCHECK=SEMANTICS is specified.

Action: Remove the PL/SQL block or specify SQLCHECK=SEMANTICS.

##### PCB-00009: cannot change MAXLITERAL after an EXEC SQL statement

Cause: The MAXLITERAL option has been used in an inline EXEC ORACLE OPTION statement after an EXEC SQL, EXEC TOOLS, or EXEC IAF statement. This is not allowed.

##### PCB-00010: SQLCHECK value in EXEC ORACLE statement exceeds command line value

Cause: The SQLCHECK option was entered inline and specified a level of checking higher than the level specified (or accepted by default) on the command line. This is not allowed. For example, if SQLCHECK={SYNTAX | LIMITED} is specified on the command line, SQLCHECK={SEMANTICS | FULL} cannot be specified inline. This informational message is; the precompiler ignores the inline value and continues processing.

Action: Revise the EXEC ORACLE statement or specify a lower level of checking on the command line.

##### PCB-00011: DBMS=V6 no longer supported; using DBMS=NATIVE

Cause: V6 compatibility is no longer supported. The precompiler will precompile as though DBMS=NATIVE was specified.

Action: Revise the specified DBMS option value from V6 to another value as desired.

### 00100 - 00199: File Manipulation Messages

##### PCB-00100: unable to reopen temporary file name

Cause: The precompiler was unable to reopen a temporary file Some possible causes follow:

- File access privileges are insufficient.
- Another user has locked the file.
- There is not enough disk space.
- There are too many open files.

Action: Check that sufficient privileges have been granted to access the file, and that it is not locked by another user. Also check that there is enough disk space and that the limit for open files is set high enough (check with the system manager).

##### PCB-00101: could not find or open system configuration file

Cause: The precompiler was unable to open the system configuration file. The system configuration file does not exist or is not in the proper directory.

Action: Check that the system configuration file is in the proper directory. See your Oracle installation documentation for where this should be. Put a new copy of PCBcob.cfg with desired default options in the proper directory.

##### PCB-00102: input file name length exceeds the maximum length

Cause: The file name length specified exceeded the maximum length. Some operating systems have a maximum file name length.

Action: Use a file name of length less than or equal to the maximum platform specific file name length.

##### PCB-00103: unable to open listing file name

Cause: The precompiler was unable to open the listing file specified by the LNAME precompiler option. Some possible causes follow:

- The filename is misspelled.
- The file does not exist.
- The search path to the file is incorrect.
- File access privileges are insufficient.
- Another user has locked the file.
- There is not enough disk space.
- There are too many open files.

Action: Check that the file exists, that the search path to the file is correct, that sufficient privileges have been granted to access the file, and that it is not locked by another user. Also check that there is enough disk space and that the limit for open files is set high enough (check with the system manager). If a listing file is not needed, specify LTYPE=NONE on the command line.

##### PCB-00104: unable to open input file name

Cause: The precompiler was unable to open the input file specified by the INAME precompiler option. Some possible causes follow:

- The filename is misspelled.
- The file does not exist.
- The search path to the file is incorrect.
- File access privileges are insufficient.
- Another user has locked the file.
- There is not enough disk space.
- There are too many open files.

Action: Check that the file exists, that the search path to the file is correct, that sufficient privileges have been granted to access the file, and that it is not locked by another user. Also check that there is enough disk space and that the limit for open files is set high enough (check with the system manager).

##### PCB-00105: included file name name exceeds name limit of num

Cause: The filename specified exceeded the maximum length. Some operating systems have a maximum file name length.

Action: Use a filename of length less than or equal to the maximum platform specific file name length.

##### PCB-00106: unable to open include file name

Cause: The precompiler was unable to open a temporary file for internal use. There might be insufficient disk space, too many open files, or read-only protection on the output directory.

Action: Check that there is enough disk space, that the limit for open files is set high enough (check with the system manager) and that protection on the directory allows opening a file for writing.

##### PCB-00107: unable to open input file name

Cause: The precompiler was unable to open the input file specified by the INAME precompiler option. Some possible causes follow:

- The filename is misspelled.
- The file does not exist.
- The search path to the file is incorrect.
- File access privileges are insufficient.
- Another user has locked the file.
- There is not enough disk space.
- There are too many open files.

Action: Check that the file exists, that the search path to the file is correct, that sufficient privileges have been granted to access the file, and that it is not locked by another user. Also check that there is enough disk space and that the limit for open files is set high enough (check with the system manager).

##### PCB-00108: unable to open list file name

Cause: The precompiler was unable to open the listing file specified by the LNAME precompiler option. Some possible causes follow:

- The filename is misspelled.
- The file does not exist.
- The search path to the file is incorrect.
- File access privileges are insufficient.
- Another user has locked the file.
- There is not enough disk space.
- There are too many open files.

Action: Check that the file exists, that the search path to the file is correct, that sufficient privileges have been granted to access the file, and that it is not locked by another user. Also check that there is enough disk space and that the limit for open files is set high enough (check with the system manager). If a listing file is not needed, specify LTYPE=NONE on the command line.

##### PCB-00109: unable to open generated source file name

Cause: The precompiler was unable to open the output file specified by the NAME precompiler option. Some possible causes follow:

- The filename is misspelled.
- The file does not exist.
- The search path to the file is incorrect.
- File access privileges are insufficient.
- Another user has locked the file.
- There is not enough disk space.
- There are too many open files.

Action: Check that the file exists, that the search path to the file is correct, that sufficient privileges have been granted to access the file, and that it is not locked by another user. Also check that there is enough disk space and that the limit for open files is set high enough (check with the system manager).

##### PCB-00110: unable to open temporary file name

Cause: The precompiler was unable to open a file for temporary use.Some possible causes follow:

- File access privileges are insufficient.
- A file of the same name already exists and is locked.
- There is not enough disk space.
- There are too many open files.

Action: Check that the file exists, that sufficient privileges have been granted to access the file, and that it is not locked. Also check that there is enough disk space and that the limit for open files is set high enough (check with the system manager).

### 00200 - 00299: Host Variable Messages

##### PCB-00200: cannot equivalence PIC N or PIC G variable name

Cause: A PIC N variable or an implicit VARCHAR group item (with a PIC N variable as an elementary item) was used in an EXEC SQL VAR statement. This is not allowed.

Action: Do not use the PIC N variable in an EXEC SQL VAR statement. If you want an equivalence to an Oracle type using an EXEC SQL VAR statement, use a PIC X variable, instead of a PIC N variable.

##### PCB-00201: indicator variable name not a group item

Cause: The host variable is a group item containing tables. Indicator variables used with this type of host variable must be group items of tables of indicators corresponding the tables in the group item host variable.

Action: Change the indicator variable to be a group item of indicator tables.

##### PCB-00202: indicator variable name not a group item or array

Cause: The host variable is a group item. Indicator variables used with this type of host variable must be a group item or table of indicator variables.

Action: Use a group item or table of indicator variables.

##### PCB-00203: nested group item name not supported

Cause: The variable used as a host variable was a group item which itself contained other group items.

Action: Remove any group items from the group item to be used as a host variable.

##### PCB-00204: nested group item cannot be used except in INTO or VALUES clause

Cause: A group item host variable was used outside of an INTO or VALUES clause. A group item host variable may be used only in an INTO or VALUES clause.

Action: Do not use a group item outside of an INTO or VALUES clause.

##### PCB-00205: cannot use PIC N or PIC G variable in PL/SQL when NLS_LOCAL=YES

Cause: A PIC N or PIC G variable was used in an embedded PL/SQL block when the precompiler option NLS_LOCAL=YES was used. A PIC N or PIC G variable is not supported in this situation.

Action: Do not use the PIC N or PIC G variable within the PL/SQL block or use precompiler option NLS_LOCAL=NO.

##### PCB-00206: cannot use N quoted literal in PL/SQL when NLS_LOCAL=YES

Cause: A \"N\" literal (a literal of the form N'...') was used within a PL/SQL block when the precompiler option NLS_LOCAL=YES was used. N literals are not supported in this situation.

Action: Use an ordinary literal (one without the \"N\") within the PL/SQL block or use precompiler option NLS_LOCAL=NO.

##### PCB-00207: invalid use of PIC N or PIC G array variable when NLS_LOCAL=YES

Cause: A PIC N variable was declared using an OCCURS clause. Tables of PIC N variables are not supported when NLS_LOCAL=YES.

Action: Declare the PIC N variable without an OCCURS clause or, do not use the PIC N variable in any SQL statements.

##### PCB-00208: incorrect type for host variable name

Cause: The host language syntax used to define a host variable in the Declare Section is incorrect.

Action: Check the syntax and the spelling, then correct the declaration.

##### PCB-00209: scale is not supported for host variable name

Cause: A variable whose format does not support scaling was used in a SQL statement or embedded PL/SQL block. The following formats do not support scaling:
PIC S9(n) COMP
PIC S9(n) COMP-4
PIC S9(n) COMP-5
PIC S9(n) BINARY
PIC 9(n) COMP

Action: Remove the scale or use a datatype that support scaling.

##### PCB-00210: DISPLAY-1 only allowed with PIC G and PIC N variables name

Cause: A variable declared with DISPLAY-1 in the usage clause without PIC G or PIC N in the picture clause was used in a SQL statement.

Action: Replace DISPLAY-1 with DISPLAY or change the picture clause to use PIC N or PIC G.

##### PCB-00211: VARYING not supported with PIC N or PIC G PICTURE clause text

Cause: The keyword VARYING was used in a PIC N variable declaration.

Action: Remove the keyword VARYING from the variable declaration. If you want to declare a PIC N VARCHAR variable, specify the precompiler option VARCHAR=YES and declare the variable as an implicit VARCHAR group item as illustrated by the following example:

    EXEC SQL BEGIN

    DECLARE SECTION END-EXEC.

        ...

               01  ENAME.

                   05  ENAME-LEN  PIC S9(4) COMP.

               05  ENAME-ARR  PIC N(20).

    ...

    EXEC SQL END DECLARE

    SECTION END-EXEC.

##### PCB-00212: PICTURE clause not allowed for host variable name

Cause: The PIC clause was used when declaring a COMP-1 or COMP-2 variable.

Action: Remove the PIC clause from the variable declaration.

##### PCB-00213: SYNCHRONIZED clause not allowed for name to be used as a host variable

Cause: The SYNC clause was used when declaring a variable that is being used as a host variable.

Action: Remove the SYNC clause from the variable declaration.

##### PCB-00214: JUSTIFIED clause not allowed for name to be used as a host variable

Cause: The JUST clause was used when declaring a variable that is being used as a host variable.

Action: Remove the JUST clause from the variable declaration.

##### PCB-00215: OCCURS TO TIMES clause not allowed for name to be used as a host variable

Cause: The OCCURS clause with the TO TIMES subclause was used when declaring a variable that is being used as a host variable.

Action: Remove the TO TIMES subclause from the variable declaration.

##### PCB-00216: OCCURS ASCENDING/DESCENDING clause not allowed for name

Cause: The OCCURS clause with the ASCENDING or DESCENDING KEY IS subclause was used when declaring a variable that is being used as a host variable.

Action: Remove the ASCENDING or DESCENDING KEY IS subclause from the variable declaration.

##### PCB-00217: OCCURS INDEXED clause not allowed for host variable name

Cause: A variable declared with an OCCURS INDEXED clause was used in a SQL statement or embedded PL/SQL block.

Action: Remove the OCCURS INDEXED clause from the variable declaration.

##### PCB-00218: RENAMES clause not allowed for host variable name t

Cause: The RENAMES clause was used when declaring a variable that is being used as a host variable.

Action: Re-declare the host variable without using the RENAMES clause.

##### PCB-00219: invalid size specified in EXEC SQL VAR statement

Cause: A size which is specified which is not valid for the specified data type.

Action: Specify a size which is valid for the specified type.

##### PCB-00220: invalid scale specified in EXEC SQL VAR statement

Cause: A scale which is specified which is not valid for the specified data type.

Action: Specify a scale which is valid for the specified type.

##### PCB-00223: undeclared variable name

Cause: A variable used in a SQL statement was not declared in the Declare Section or its name is misspelled.

Action: Add or correct the variable declaration.

##### PCB-00224: ambiguously referenced variable name

Cause: There is more than one variable of the same name and the qualification given was insufficient to determine which variable the reference was to.

Action: Use more complete qualification in the variable reference.

##### PCB-00225: undeclared SQL identifier name

Cause: The name of a descriptor, statement, or cursor was not declared or is misspelled, or was declared as a different kind of SQL identifier.

Action: Add or correct the descriptor, statement, or cursor declaration.

##### PCB-00226: SQL identifier name already defined

Cause: The SQL identifier (cursor name, statement name, etc.) has already been defined in another way.

Action: Do not redefine the SQL identifier. Use a different name.

##### PCB-00227: undeclared indicator variable name

Cause: An indicator variable used in a SQL statement was not declared in the Declare Section or its name is misspelled.

Action: Add or correct the indicator variable declaration.

##### PCB-00228: invalid group item variable name

Cause: An unacceptable group item variable was used in a SQL statement or its name is misspelled.

Action: Correct the group item variable declaration or its use in the SQL statement.

##### PCB-00229: indicator variable name has wrong type or length

Cause: An indicator variable was not declared in the Declare Section as a 2-byte integer. Indicator variables must be defined as 2-byte integers.

Action: Redefine the indicator variable as a 2-byte integer.

##### PCB-00230: indicator array size must not be less than its host variable

Cause: A host variable array was used with an indicator array declared with a smaller dimension. For example:

    EXEC SQL BEGIN DECLARE SECTION END-EXEC.

    01  EMP-NUM       OCCURS 4 TIMES PIC S9(4) COMP.

    01  EMP-NUM-IND   OCCURS 2 TIMES PIC S9(4) COMP.

    EXEC SQL END DECLARE SECTION END-EXEC.

    ...
    SELECT ... INTO EMP-NUM:EMP-NUM-IND ...

Action: Increase the size of the indicator array.

##### PCB-00231: host and indicator variables may not have the same name.

Cause: In an EXEC SQL statement, an indicator variable had the same name as a host variable. The names of a host variable and its associated indicator variable must be different. Also, an indicator variable cannot be used as a host variable.

Action: Rename the host or indicator variable.

##### PCB-00232: tables not allowed as input bind variables in SELECT statement

Cause: A host table was used in the WHERE clause of a SELECT-INTO statement or in the SELECT list of a SELECT-INTO statement.

Action: Rewrite the SELECT statement without using tables or use a cursor.

##### PCB-00233: table size mismatch in INTO/USING. Minimum is: num

Cause: The size of a table variable in an INTO/USING clause is too small for the number of rows processed.

Action: Declare all table variables in the INTO/USING clause to have at least the minimum dimension given.

##### PCB-00234: FOR variable name is invalid type

Cause: The count variable in a FOR clause has the wrong datatype. The datatype must be NUMBER or LONG (or be compatible with NUMBER or LONG).

Action: Check the declaration and check that the count variable has a datatype of NUMBER or LONG (or a compatible Oracle or host-language datatype).

### 00300 - 00399: FIPS Flagging Messages

##### PCB-00300: datatype for host variable not supported by ANSI name

Cause: An Oracle extension to the ANSI/ISO standard was used. Specifically, a pointer or nonconforming datatype such as VARCHAR was used. For example, the offending code might look like:

    EXEC SQL BEGIN DECLARE SECTION END-EXEC.

               01  USERNAME          PIC X(10) VARYING

               EXEC SQL END DECLARE SECTION END

    This informational message is issued by the FIPS Flagger when FIPS=YES.

Action: No action is required.

##### PCB-00301: use of non-ANSI function is an Oracle extension

Cause: An Oracle extension to the ANSI/ISO SQL standard was used. Specifically, a non-ANSI function was used. This informational message is issued by the FIPS Flagger when FIPS=YES.

Action: No action is required. However, for ANSI/ISO compliance, do not use this function.

##### PCB-00302: this statement is not supported by ANSI

Cause: An Oracle extension to the ANSI/ISO SQL standard was used. Specifically, a nonconforming SQL statement such as PREPARE was used. For example, the offending code might look like:

    EXEC SQL PREPARE sql_statement FROM :HV END-EXEC.

    This informational message is issued by the FIPS Flagger when FIPS=YES.

Action: No action required. However, for ANSI/ISO compliance, do not use the nonconforming statement.

##### PCB-00303: dynamic SQL and PL/SQL are Oracle extensions to ANSI SQL

Cause: An Oracle extension to the ANSI/ISO SQL standard was used. Specifically, dynamic SQL or embedded PL/SQL was used. For example, the offending code might look like:

    EXEC SQL EXECUTE

              BEGIN

                  SELECT

    ...

     END;

     END-EXEC.

    This informational message is issued by the FIPS Flagger when FIPS=YES.

Action: No action required. However, for ANSI/ISO compliance, do not use dynamic SQL or embedded PL/SQL.

##### PCB-00304: Oracle extension to the WHENEVER statement

Cause: An Oracle extension to the ANSI/ISO SQL standard was used. Specifically, a nonconforming keyword such as NOTFOUND, STOP, RAISE, or DO was used in the WHENEVER statement. (Note that NOT FOUND is ANSI-compliant.) For example, the offending code might look like:

    EXEC SQL WHENEVER SQLERROR STOP END-EXEC.

    This informational message is issued by the FIPS Flagger when FIPS=YES.

Action: No action required. However, for ANSI/ISO compliance, do not use the nonconforming keyword.

##### PCB-00305: Oracle extension to the COMMIT and ROLLBACK statements

Cause: An Oracle extension to the ANSI/ISO SQL standard was used. Specifically, the parameter RELEASE, COMMENT, or FORCE were used in a COMMIT or ROLLBACK statement. For example, the offending code might look like:

    EXEC SQL ROLLBACK RELEASE END-EXEC.

    This informational message is issued by the FIPS Flagger when FIPS=YES.

Action: No action required. However, for ANSI/ISO compliance, do not use the nonconforming parameter.

##### PCB-00306: CREATE FUNCTION/PROCEDURE/PACKAGE/TRIGGER are Oracle extensions

Cause: An Oracle extension to the ANSI/ISO SQL standard was used. Specifically, one of the following statements was used:

- CREATE FUNCTION
- CREATE PROCEDURE
- CREATE PACKAGE
- CREATE TRIGGER

This informational message is issued by the FIPS Flagger when FIPS=YES.

Action: No action is required. However, for ANSI/ISO compliance, do not use any of these statements.

##### PCB-00307: DROP TABLE statement is an Oracle extension

Cause: An Oracle extension to the ANSI/ISO SQL standard was used. Specifically, the DROP TABLE statement was used. This informational message is issued by the FIPS Flagger when FIPS=YES.

Action: No action is required. However, for ANSI/ISO compliance, do not use the DROP statement.

##### PCB-00308: FOR clause is an Oracle extension

Cause: An Oracle extension to the ANSI/ISO SQL standard was used. Specifically, the FOR clause was used in an array-processing SQL statement. For example, the offending code might look like:

    EXEC SQL FOR :limit INSERT INTO EMP (EMPNO, JOB, DEPTNO)

    VALUES (:emp_number, :job_title, :dept_number) END-EXEC

    This informational message is issued by the FIPS Flagger when FIPS=YES.

Action: No action required. However, for ANSI/ISO compliance, do not use the FOR clause.

##### PCB-00309: The CONNECT statement is Oracle implementation dependent

Cause: An Oracle extension to the ANSI/ISO SQL standard was used. Specifically, the CONNECT statement was used to log on to ORACLE. For example, the offending code might look like:

    EXEC SQL CONNECT :username IDENTIFIED BY :password END-EXEC.

    This informational message is issued by the FIPS Flagger when FIPS=YES.

Action: No action required. However, for ANSI/ISO compliance, specify the AUTO_CONNECT command-line option instead of using a CONNECT statement.

##### PCB-00310: AT clause is an Oracle extension

Cause: An Oracle extension to the ANSI/ISO SQL standard was used. Specifically, the AT <db_name> clause was used in a SQL statement. For example, the offending code might look like:

    EXEC SQL AT oracle3 COMMIT RELEASE END-EXEC.

    This informational message is issued by the FIPS Flagger when FIPS=YES.

Action: No action required. However, for ANSI/ISO compliance, do not use the AT <db_name> clause.

##### PCB-00311: datatype equivalencing is an Oracle extension

Cause: An Oracle extension to the ANSI/ISO SQL standard was used. Specifically, the EXEC SQL VAR statement was used.

Action: No action required. However, for ANSI/ISO compliance, do not use the EXEC SQL VAR statement.

##### PCB-00312: keyword WORK required here by ANSI

Cause: An Oracle extension to the ANSI/ISO SQL standard was used. Specifically, the keyword WORK was used in a COMMIT or ROLLBACK statement. For example, the offending code might look like:

    EXEC SQL COMMIT WORK RELEASE END-EXEC.

    This informational message is issued by the FIPS Flagger when FIPS=YES.

Action: No action required. However, for ANSI/ISO compliance, do not use the keyword WORK.

##### PCB-00313: TO SAVEPOINT clause is an Oracle extension

Cause: An Oracle extension to the ANSI/ISO SQL standard was used. Specifically, the TO SAVEPOINT <save_id> clause was used in a ROLLBACK statement.

Action: No action required. However, for ANSI/ISO compliance, do not use the TO SAVEPOINT clause.

##### PCB-00314: DECLARE DATABASE is an Oracle extension

Cause: An Oracle extension to the ANSI/ISO SQL standard was used. Specifically, the DECLARE DATABASE statement was used.

Action: No action required. However, for ANSI/ISO compliance, do not use this statement.

##### PCB-00315: DECLARE TABLE is an Oracle extension

Cause: An Oracle extension to the ANSI/ISO SQL standard was used. Specifically, the DECLARE TABLE statement was used.

Action: No action required. However, for ANSI/ISO compliance, do not use this statement.

##### PCB-00316: SQL FORMS statements are Oracle extensions

Cause: An Oracle extension to the ANSI/ISO SQL standard was used. Specifically, the one of the following statements was used:

- EXEC IAF GET
- EXEC IAF PUT
- EXEC TOOLS GET
- EXEC TOOLS SET

This informational message is issued by the FIPS Flagger when FIPS=YES.

Action: No action is required. However, for ANSI/ISO compliance, do not use any of these statements.

##### PCB-00317: group item host variables are Oracle extensions

Cause: An Oracle extension to the ANSI/ISO SQL standard was used. Specifically, a group item variable was used as a host variable. This informational message is issued by the FIPS Flagger when FIPS=YES.

Action: No action is required. However, for ANSI/ISO compliance, do not use group items as host variables.

##### PCB-00318: ARRAYLEN is an Oracle extension

Cause: An Oracle extension to the ANSI/ISO SQL standard was used. Specifically, the ARRAYLEN statement was used. This informational message is issued by the FIPS Flagger when FIPS=YES.

Action: No action is required. However, for ANSI/ISO compliance, do not use this statement.

##### PCB-00319: EXEC ORACLE statements are an Oracle extension

Cause: An Oracle extension to the ANSI/ISO SQL standard was used. Specifically, an EXEC ORACLE statement was used. This informational message is issued by the FIPS Flagger when FIPS=YES.

Action: No action is required. However, for ANSI/ISO compliance, do not use this statement.

##### PCB-00320: VARYING host variable name is an Oracle extension

Cause: An Oracle extension to the ANSI/ISO SQL standard was used. Specifically, a variable declared of VARYING type was used in a SQL statement. This informational message is issued by the FIPS Flagger when FIPS=YES.

Action: No action is required. However, for ANSI/ISO compliance, do not use this statement.

##### PCB-00321: implicit varchar host variables are an Oracle extension

Cause: An Oracle extension to the ANSI/ISO SQL standard was used. Specifically, an implicit VARCHAR variable was used in a SQL statement. This informational message is issued by the FIPS Flagger when FIPS=YES.

Action: No action is required. However, for ANSI/ISO compliance, do not use this statement.

### 00400 - 00499: Tokenizer or Parsing Messages

##### PCB-00400: text

Cause: A generic tokenizer error was found.

Action: Do the appropriate action to fix the indicated error.

##### PCB-00401: character string not properly terminated

Cause: The character string was not terminated with a quote or apostrophe as appropriate or line continuation was not correct.

Action: Check that the character string is terminated properly and that line continuation syntax is correct.

##### PCB-00402: pseudo-text not properly terminated

Cause: A block of pseudo-text has not been properly terminated with "==".

Action: Terminate the pseudo-text at the appropriate place with "==".

##### PCB-00403: EXEC statement cannot begin in Area A

Cause: An EXEC statement began in Area A (before column 12).

Action: Shift the EXEC statement to the right to start it in Area B (in or after column 12).

### 00500 - 00524: Thread Messages

##### PCB-00500: No EXEC SQL CONTEXT USE statement encountered

Cause: No EXEC SQL CONTEXT USE statement was encountered and the option threads=yes was requested.

Action: Ensure that the necessary context variable (of type sql_context) has been declared, ALLOCATEd, and USEd prior to any executable SQL statements.

##### PCB-00501: runtime context variable name not of correct type

Cause: The runtime context variable referenced in an EXEC SQL CONTEXT USE statement is not of type sql_context.

Action: Declare your runtime context variable of type sql_context.

##### PCB-00502: this statement can only be used with THREADS=YES

Cause: EXEC SQL ENABLE THREADS or one of the EXEC SQL CONTEXT statements has been used, even though option THREADS is set to NO.

Action: Specify option THREADS=YES or remove the EXEC ENABLE THREADS or EXEC SQL CONTEXT statement from the source code.

### 00525 - 00549: Result Set Cursor Messages

##### PCB-00525: use of the AT clause is not permitted here

Cause: An explicit AT clause was used with an ALLOCATE statement or a FETCH/CLOSE statement also using a sql-cursor declaration.

Action: Remove the AT clause.

### 00550 - 00574: Miscellaneous Messages

##### PCB-00550: unable to log on to ORACLE with name. ORACLE error number: num

Cause: The precompiler was unable to log on to ORACLE with the specified username and password. An ORACLE error with given number occurred when the logon was attempted.

Action: Lookup indicated ORACLE database error message and take appropriate action.

##### PCB-00551: the SQLCA has already been included

Cause: The precompiler has encountered an include SQLCA statement after SQLCA has already been included. The SQLCA can only be included once.

Action: Remove the duplicate include SQLCA statement.

##### PCB-00552: the SQLCA and a SQLCODE variable cannot both be used

Cause: The SQLCA has been included and a SQLCODE variable has been declared. This is not allowed as references to the SQLCODE variable are ambiguous and will result in COBOL compiler errors.

Action: Use either the SQLCA or the SQLCODE variable. Remove either the include of the SQLCA or the SQLCODE variable declaration.

##### PCB-00553: FOR clause not allowed on SELECT statement

Cause: A FOR clause was used with a SELECT statement. This is not allowed as data returned from the last loop in the execution of the SELECT overwrites data returned in a previous loop.

Action: Remove the FOR clause from the SELECT statement and use a host- language construct to iteratively execute the SELECT statement.

##### PCB-00554: must EXEC SQL INCLUDE SQLCA when mode=ANSI and WHENEVER SQLWARNING used

Cause: When MODE={ANSI | ANSI14}, an attempt was made to use the WHENEVER SQLWARNING statement without declaring the SQLCA. When MODE={ANSI | ANSI14}, declaring the SQLCA is optional, but to use the WHENEVER SQLWARNING statement, the SQLCA must be declared.

Action: Remove all WHENEVER SQLWARNING statements from the program or declare the SQLCA by hardcoding it or copying it into the program with the INCLUDE statement.

##### PCB-00555: using WHERE CURRENT OF on cursor defined without FOR UPDATE clause

Cause: If mode=ORACLE, then a cursor defined with a WHERE CURRENT OF clause must also have a FOR UPDATE clause.

Action: Rewrite the cursor definition.

##### PCB-00556: unrecoverable error. Fix previous errors and re-precompile

Cause: A fatal parsing error or token stack overflow error has been encountered.

Action: Fix the syntax error that is causing the parsing error.

##### PCB-00557: USING clause can only be used on a PREPAREd dynamic statement

Cause: A severe semantics error occurred because the USING clause was used with the OPEN cursor statement and the cursor declaration is not for a PREPAREd statement. The correct sequence of statements should be:

    EXEC SQL prepare sv from :sel_stmt END-EXEC

    EXEC SQL declare csv cursor for sv END-EXEC

    EXEC SQL open csv USING :hv1, :hv2 END-EXEC

Action: Use the PREPARE statement for the SQL statement and use that in the DECLARE CURSOR statement.

##### PCB-00558: unrecoverable error encountered during semantics processing

Cause: A severe semantics error such as an unacceptable sql type in the EXEC SQL VAR statement was encountered.

Action: Provide an acceptable sql type in the EXEC SQL VAR statement or fix the problem causing the severe error.

### 00575 - 00599: PL/SQL (including ARRAYLEN) Messages

##### PCB-00575: PLS-num: text

Cause: Refer to the indicated PL/SQL error message for the indicated condition.

Action: Refer to the indicated PL/SQL error message to correct the SQL statement or embedded PL/SQL block.

##### PCB-00576: PLS-num: text

Cause: The precompiler found an error in an embedded SQL statement or PL/SQL block.

Action: Refer to the indicated PL/SQL error message to correct the SQL statement or embedded PL/SQL block.

##### PCB-00577: use of ARRAYLEN with SQL bind arrays is ignored

Cause: ARRAYLEN is only valid with PL/SQL arrays.

Action: Use an appropriate array type.

##### PCB-00578: variable name must be an array

Cause: In an ARRAYLEN statement, the name of a previously declared host table was not specified. The first host variable in an ARRAYLEN statement must be a table. The second host variable, whichspecifies an array dimension, must be a 4-byte integer. The correct syntax follows:

    EXEC SQL ARRAYLEN host_table (dimension) END-EXEC.

    The ARRAYLEN statement must appear along with, but somewhere after, the declarations of host_table and dimension.

Action: Check the spelling of both identifiers in the ARRAYLEN statement. If necessary, supply the missing host table name.

##### PCB-00579: invalid ARRAYLEN length variable type for name

Cause: A valid table dimension was not specified in an ARRAYLEN statement. The table dimension must be specified using a previously declared 4-byte integer host variable, not a literal or expression. For example, the offending code might look like:

    EXEC SQL ARRAYLEN ename_array (25) END-EXEC  -- illegal dimension

Action: Supply a valid table dimension. If necessary, declare a 4-byte integer host variable for use in the ARRAYLEN statement.

##### PCB-00580: Previous use of host variable name uses different indicator

Cause: Within a PL/SQL statement, a host variable was used with two different indicator variables or was used with an indicator variable in one instance and without an indicator in another instance.

Action: Change all references to the host variable so that they all use the same indicator variable or all use no indicator variable.

##### PCB-00581: name used as both host variable and indicator

Cause: Within a PL/SQL statement, the variable was used as both a host variable and an indicator variable.

Action: Use different variables for host variables and indicator variables.

### 00600 - 00624: EXEC TOOLS Messages

##### PCB-00600: indicators are not allowed in EXEC IAF statements

Cause: Indicator variables associated with host variables cannot be used in EXEC IAF statements such as GET and PUT in a user exit.

Action: Eliminate the indicator variables. If feasible (for example with Forms V4), use EXEC TOOLS statements, which do allow indicator variables. See the Programmer's Guide to the Oracle Precompilers for more information of EXEC IAF and EXEC TOOLS statements.

##### PCB-00601: an EXEC TOOLS host variable context name is not type char

Cause: If a host variable is used to define a context name in an EXEC TOOLS GET CONTEXT or EXEC TOOLS SET CONTEXT statement, that host variable must be of a character type.

Action: Declare the context name to a host variable of a char type.

##### PCB-00602: an EXEC TOOLS host pointer variable is not a pointer

Cause: The host variable specifying an EXEC TOOLS context must be of a pointer type.

Action: Declare the context host variable to be a pointer type.

##### PCB-00603: an EXEC TOOLS MESSAGE host variable is not type char

Cause: If a host variable is used to specify the message in an EXEC TOOLS MESSAGE statement, that host variable must be of a character type.

Action: Declare the message to a host variable of a char type.

##### PCB-00901: Pro*COBOL internal error condition detected (Code = num)

Cause: Pro*COBOL had detected an abnormal condition in its internal data structures. This error message should not normally ever be produced. Customer service should be contacted to report the error.

Action: Correct any other errors which have been reported. If the internal errors still exist, examine the source code where the condition was detected and try modifying it in some way. Possibly this will alleviate the internal error condition.

##### PCB-00902: unable to read message file, facility PCB

Cause: Pro*COBOL was unable to access the message file containing message text. The file is possibly corrupt.

Action: Contact customer support for information on reinstalling the Pro*COBOL message files.

##### PCB-00903: Pro*COBOL is unable to initialize its parser function

Cause: Pro*COBOL was unable to access the message file containing message text. The file is possibly corrupt.

Action: Contact customer support for information on reinstalling the Pro*COBOL message files.

02010-02400: Oracle Precompiler: Pro*C/C++ Release 3.0 Messages

##### PCC-02010: found end-of-file while scanning string literal

Cause: A string in a SQL statement, which should be delimited by single quotation marks, was not terminated properly.

Action: Check that all strings are delimited.

##### PCC-02011: found identifier greater than 128 characters (truncated)

Cause: The precompiler found an identifier that was too long.

Action: Shorten the identifier. SQL identifiers should be limited to 18 characters.

##### PCC-02012: did not find a matching quote for CHAR constant

Cause: A character constant with a single quotation mark was not terminated.

Action: Terminate the character constant.

##### PCC-02013: unknown escape sequence

Cause: The precompiler found an escape sequence that it could not process inside a string literal. This error can arise when multi-byte character strings that can contain shift-in or shift-out escape sequences are used.

Action: Correct the string representation.

##### PCC-02014: syntax error at line num, column colnam, file name

Cause: The precompiler detected an error in C or embedded SQL syntax. This message is followed by a more specific error message.

Action: Correct the syntax error.

##### PCC-02015: unable to open include file

Cause: The precompiler could not open a header file that was specified using the #include preprocessor directive or the EXEC SQL INCLUDE statement. This can happen if the file specification is inaccurate or if read permission or read access rights on the file or on one or more of the directories in the path were not granted.

Action: Recheck that the file specification is correct, that the file exists, and that read permission has been granted so that the file can be read.

##### PCC-02016: include file pathname is too long

Cause: The pathname for include files exceeded the maximum length of 80 characters.

Action: Move the include file, or create an environment variable or logical to shorten the pathname.

##### PCC-02017: unable to open output file

Cause: The precompiler could not open an output file. This could be a generated code output file (.c file) or a listing file. This message can result from many causes. For example:

- A pathname for a specified output file contains a non-existent directory.
- An operating-system error occurred because the file system or disk is full.
- Write permission on the specified directory or directories in the path do not exist.

Action: Track down the cause of the error, as suggested above, and correct it.

##### PCC-02018: found end-of-file while scanning comment

Cause: A C comment, either in C code or in an embedded SQL statement, was not terminated.

Action: Find the unterminated comment and terminate it with */.

##### PCC-02019: preprocessor warning at line num, column colnam, file name

Cause: This message indicates that a warning condition occurred as the precompiler was doing the preprocessor pass. A more specific warning message will follow this message.

Action: Correct the condition according to the action specified for the message that follows.

##### PCC-02020: preprocessor error at line num, column colnam, file name

Cause: This message indicates that an error condition occurred as the precompiler was in the preprocessing phase. A more specific error message will follow this message.

Action: Correct the error according to the action specified for the message that follows.

##### PCC-02021: found newline while scanning string literal

Cause: A string constant contains a newline character. For example,

    char x[] = "Hello

    world";

Action: Remove the newline character.

##### PCC-02022: found end of file while scanning a SQL statement

Cause: The precompiler encountered an end of file while parsing an EXEC SQL statement.

Action: Add the statement terminator(;) or complete the EXEC SQL statement.

##### PCC-02023: found end of file while scanning a PL/SQL statement

Cause: The precompiler encountered an end of file while parsing a PL/SQL statement (exec sql execute ...).

Action: Complete the PL/SQL statement.

##### PCC-02024: NCHAR literals are not permitted inside PL/SQL blocks

Cause: The precompiler found a multi-byte character string in an embedded PL/SQL statement. For example, the offending code might look like

    exec sql execute

             declare

                  name char(10) := N'Matsuda';

             begin

                 ....

            end;

    end-exec;

Action: Remove multi-byte character string from the PL/SQL block or rewrite the declaration without using NLS_CHAR.

##### PCC-02025: NLS_LOCAL should be TRUE when using NCHAR literals

Cause: The precompiler detected a multi-byte character host variable (NCHAR literal) when the option NLS_LOCAL was not set to TRUE on the command line. When NLS_LOCAL=TRUE, the runtime library (SQLLIB) performs blank-padding and blank-stripping for host variables that are of multi-byte types.

Action: Specify NLS_LOCAL=TRUE on the command line.

##### PCC-02035: CMD-LINE: CONFIG= option is invalid in a config file

Cause: A user configuration file inside a user configuration file cannot be specified. That is, nested configuration files cannot be nested.

Action: If there are nested configuration files, move the options from the nested files to the top-level file.

##### PCC-02040: CMD-LINE: Option selected, but no value provided

Cause: An option on the command line was specified, but a value for it was not included. For example, the offending code might look like:

    proc ina=sample1 oname=

    could trigger this error message.

Action: Provide a value for the option.

##### PCC-02041: CMD-LINE: Option does not exist:

Cause: A non-existent option on the command line was specified.

Action: See the Programmer's Guide to the Oracle Precompilers for a list of the valid command-line options and their possible values.

##### PCC-02043: CMD-LINE: Option syntax is incorrect

Cause: A value for a command-line option was incorrectly specified.

Action: See the Programmer's Guide to the Oracle Precompilers for the correct syntax for specifying command-line option values.

##### PCC-02044: CMD-LINE: Illegal or out of range value for option: option string

Cause: A value specified for a command-line option was not within the accepted range. For example, the range for the MAXOPENCURSORS option is 5 to 256. If a value outside this range is specified, this message is triggered.

Action: See the Programmer's Guide to the Oracle Precompilers for the ranges that option values can take.

##### PCC-02045: CMD-LINE: Option is not unique: option name

Cause: An option name was partially specified on the command line that made it non unique. For example, in the command line

    proc in=t.pc

    the "in" option can imply either the iname or include option.

Action: Provide sufficient characters on the command line to make the option name unique.

##### PCC-02046: CMD-LINE: Unable to open config file: filename

Cause: A non-existent user configuration file was specified on the command line with the config option.

Action: Provide a valid filename for the configuration file.

##### PCC-02047: CMD-LINE: Option is not allowed inline: option string

Cause: An option was entered inline that can only be entered on the command line or in a configuration file. For example, the offending code might look like

    EXEC ORACLE option (nls_char=<name>);

    The nls_char option can only be entered on the command line or in a configuration file.

Action: Remove the option from the source file, and specify it on the command line.

##### PCC-02066: CMD-LINE: Could not find or could not open system config file

Cause: The system configuration file has a standard name (pmscfg.h) and a location that is operating-system dependent. On UNIX systems, it is located in the $ORACLE_HOME/proc directory. If a file named pmscfg.h is not found in the standard location, this warning message is issued.

Action: Create a system configuration file in the standard location. The file can be empty. See also the operating system-specific Oracle documentation.

##### PCC-02081: CMD-LINE: Unterminated option value list or value list was truncated

Cause: An option that takes a list of values was entered. The value list did not have a closing parenthesis. This error may also occur if the list of values entered on a single line was too long and Pro*C truncated it.

Action: Ensure that all value lists are terminated with a closing parenthesis. Split long value lists into individual entries.

##### PCC-02100: unable to initialize PL/SQL

Cause: The precompiler connected to Oracle but could not invoke the PL/SQL engine. This error can result if an earlier release of Oracle is used without the Procedural Option.

Action: To use PL/SQL, upgrade to a more recent release of Oracle.

##### PCC-02101: unable to open input file

Cause: The precompiler could not open the input file. This is the .pc file specified in the INAME= option. This means that the file does not exist, that a directory was incorrectly specified in the pathname, or that the person running the precompiler does not have read permission for the file.

  This message could also result from operating-system errors. For example, an unmounted file system or disk I/O errors, could trigger this error.

Action: Check that permission to read the file exists and that the full pathname has been specified correctly. Check for operating system-specific problems. See also the operating system-specific Oracle documentation.

##### PCC-02102: fatal error while doing C preprocessing

Cause: The precompiler issues this message after a more specific message.

Action: Correct the problem specified in the previous message or messages.

##### PCC-02103: please enter your password:

Cause: The username was specified on the command line without a password. For example:

    proc sqlcheck=full iname=sample1.pc userid=scott/

Action: Re-enter the command line, and include the password.

##### PCC-02104: unable to connect to Oracle

Cause: The precompiler could not connect to Oracle with the username, password, and, if applicable, database link that was supplied. Note that this is a precompiler message, not a run time message. This means that the USERID option value, either on the command line or in a configuration file, was incorrect.

Action: Check that the username and password are current and correct. Run SQL*DBA or SQL*Plus and verify that connection can be made using that username and password.

##### PCC-02105: unable to open list file

Cause: The precompiler could not open the listing file. This message can result from many causes. For example:

- A pathname for a specified listing file contains a non-existent directory.
- An operating-system error occurred because the file system or disk is full.
- Write permission on the specified directory has not been granted.

Action: Track down the cause of the error, as suggested above, and correct it.

##### PCC-02106: USERID only used when SQLCHECK=FULL, userid ignored

Cause: The USERID option was specified on the command line, but SQLCHECK was not equal to FULL or SEMANTICS. The USERID has no effect, unless SQLCHECK=FULL or SQLCHECK=SEMANTICS.

Action: This is a warning message only.

##### PCC-02107: you may not specify PARSE = FULL when CODE = CPP

Cause: The PARSE=FULL and CODE=CPP options were both specified on the command line. The PARSE=FULL option invokes the C parser, which does not understand any C++ constructs generated by the precompiler with CODE=CPP option.

Action: Set the PARSE option to either NONE or PARTIAL if the CODE=CPP option is specified.

##### PCC-02108: UNSAFE_NULL=YES allowed if MODE=ORACLE and DBMS=V7 or V8

Cause: UNSAFE_NULL=YES was specified on the command line, but either the MODE option was not ORACLE or the DBMS option was not V7 or V8.

Action: Specify MODE=ORACLE and DBMS=V7 or V8 when using UNSAFE_NULL=YES.

##### PCC-02109: SQLCHECK=NONE is not yet supported, using SYNTAX

Cause: SQLCHECK=NONE was specified on the command line but is not supported in this release. SQLCHECK=SYNTAX was used instead.

Action: This is a warning message only. To avoid this warning, specify SQLCHECK=SYNTAX or SQLCHECK=SEMANTICS.

##### PCC-02110: DBMS=V6_CHAR is deprecated. Use CHAR_MAP=VARCHAR2, DBMS=V7 instead

Cause: DBMS=V6_CHAR was specified on the command line but is a no longer supported option. The options CHAR_MAP=VARCHAR2 andDBMS=V7 were used instead.

Action: This is a warning message only. To avoid this warning, specify CHAR_MAP=VARCHAR2 and, if required, DBMS=V7.

##### PCC-02111: CHAR_MAP option ignored. Only CHAR_MAP=VARCHAR2 allowed for DBMS=V6

Cause: DBMS=V6 was specified, and CHAR_MAP was specified with a value other than VARCHAR2. The CHAR_MAP value is ignored.

Action: This is a warning message only. To avoid this warning, specify a DBMS value other than DBMS=V6 or use CHAR_MAP=VARCHAR2.

##### PCC-02112: OBJECTS option ignored. OBJECTS=YES is not allowed for DBMS=V6 or V7.

Cause: OBJECTS=YES was specified on the Pro*C command line, but the DBMS option value was not valid.

Action: This is a warning message only. To avoid this warning for OBJECTS=YES, use DBMS=V8 or DBMS=NATIVE with a V8 database.

##### PCC-02129: CMD-LINE: Client supplied static options table is invalid

Cause: This is an internal error message not usually issued.

Action: Call Oracle customer support.

##### PCC-02132: CMD-LINE: Could not allocate memory

Cause: This is an internal error message not usually issued.

Action: Call Oracle customer support.

##### PCC-02133: CMD-LINE: Error processing string function

Cause: This is an internal error message not usually issued. It indicates that a C string function, such as strcpy or strlen, returned an error.

Action: Call Oracle customer support.

##### PCC-02134: CMD-LINE: Null option supplied

Cause: A zero length option was specified on the command line.

Action: Re-enter the command line with a valid option.

##### PCC-02135: CMD-LINE: User asked for help

Cause: This is a final message that the precompiler issues when information about the command-line options has been requested. For example, if the command

    proc ?

    is issued to get a list of the current default values for the command-line options, this message appears at the end of the list.

Action: No action required.

##### PCC-02138: CMD-LINE: Internal consistency error

Cause: This is an internal message for program exceptions. An unexpected condition was encountered by the command-line processor and a consistency check failed. Some possible causes of this message include:

- invalid command-line options
- memory corruption

Action: Report this error to Worldwide Support after gathering the following information:

- the events that led to the error
- the attempted operations that led to the error
- any unusual circumstances prior to this error

##### PCC-02144: CMD-LINE: Blank characters are not allowed on either side of an equal sign (=)

Cause: An equal sign (=) was either immediately preceded or followed by a blank character.

Action: Precompile your program again without blank characters on either side of any equal sign (=) on the command line.

##### PCC-02150: error at line num, column num in file name

Cause: An error was encounter at the given location.

Action: Check the named source file and correct the error using the additional information which follows this error message.

##### PCC-02151: line num column num file name:

Cause: An error was encounter at the given location.

Action: Check the listed source file and correct the error using the additional information which follows this error message.

##### PCC-02152: unable to open file name to display or list the source line num

Cause: The file contains an error, but could not be reopened to list or display the incorrect line.

Action: Check that the file is intact and it has read permission. Then rerun the operation.

##### PCC-02153: open file: name

Cause: A new source file was opened while producing the list file.

Action: No action required; this is an informational message.

##### PCC-02154: close file: name

Cause: A source file was closed while producing the list file.

Action: No action required; this is an informational message.

##### PCC-02200: found unrecognized punctuation sequence

Cause: This error indicates that the precompiler parser encountered a badly-formed identifier or keyword.

Action: Correct the syntax.

##### PCC-02201: found syntax error

Cause: This general message precedes one or more specific messages that detail the nature of the error.

Action: No action required. Correct the errors diagnosed in the following message(s).

##### PCC-02202: no TYPEDEF name was given

Cause: The precompiler parser encountered a TYPEDEF statement that had no name after the type specification. For example

    typedef int;

Action: Correct the syntax.

##### PCC-02203: found end of file when not expected

Cause: The parser can emit this message when a general syntax error occurs, for example, an unmatched `{' or `('.

Action: Correct the syntax.

##### PCC-02204: EXEC SQL INCLUDE not permitted from within an included file

Cause: EXEC SQL INCLUDE statements cannot be nested. Also, an EXEC SQL INCLUDE statement cannot be put inside a file that is included using the #include preprocessor command.

Action: Recode the program so that the nested include statement is not required.

##### PCC-02205: parser error at line num, column colnam, file name

Cause: The precompiler parser encountered a syntax error, either in C code or in SQL code. A more specific message should follow.

Action: No action required for this message. Take the appropriate action for any following messages.

##### PCC-02206: host variables are not permitted within a DDL statement

Cause: A Data Definition Language statement cannot use host variables. For example, the statement

    CREATE TABLE :table_name (c1 char(10));

    is illegal, because the name of the table in a CREATE TABLE statement cannot be represented using a host variable.

Action: Use dynamic SQL to create the names of database objects (tables, views, columns, etc.) at runtime. See the Programmer's Guide to the Oracle Precompilers for information about dynamic SQL.

##### PCC-02207: invalid macro name

Cause: The precompiler parser encountered a #DEFINE directive that had no macro name associated with it. For example,

    #define

Action: Correct the syntax.

##### PCC-02208: no filename specified in #include statement

Cause: The precompiler parser encountered a #INCLUDE directive that had no filename associated with it. For example,

    #include

Action: Specify appropriate filename with the #INCLUDE directive, or correct the syntax.

##### PCC-02209: macro invocation has incorrect number of arguments

Cause: A macro invocation in the source does not have the same number of arguments as the macro definition in the #DEFINE line.

Action: Correct the macro reference or the macro definition.

##### PCC-02210: C++ punctuation sequences are not permitted

Cause: C++ punctuation sequences are not supported by the Pro*C/C++ precompiler.

Action: Rewrite your C++ code without using punctuation sequences and precompile it again.

##### PCC-02301: cannot open input file for reading

Cause: The semantic analysis phase of the precompiler could not re-open the input file to generate output code.

Action: Check that the input file and its directory's protections and privileges do not change during precompilation.

##### PCC-02302: cannot open code generation output file name

Cause: The precompiler was not able to open one or both of the temporary files that are required for code generation. The user executing the precompiler must have write permission (and/or the appropriate privileges) on the current directory.

Action: Check that permission exists to create files in the directory where you precompile.

##### PCC-02303: cannot open include file

Cause: The precompiler was not able to open a header file specified using the #INCLUDE preprocessor directive or the EXEC SQL INCLUDE statement. This can happen if the file specification is inaccurate or if read permission or read-access rights on the file or on one or more of the directories in the path have not been granted.

Action: Recheck that the file specification is correct, that the file exists, and that read permission has been granted so that the file can be read.

##### PCC-02304: invalid declaration of C function

Cause: A C function using invalid syntax was declared.

Action: Consult a C programming manual and correct the declaration.

##### PCC-02305: illegal mixing of new and old style C function declarations

Cause: All C functions using either the traditional style (K&R style) function declarations or the new (ANSI) style must be declared; the two styles cannot be mixed.

Action: Adopt a consist declaration style for functions.

##### PCC-02306: illegal name of C function

Cause: A C function was declared with a name that is not a legal C identifier.

Action: Use legal C identifiers for all function names.

##### PCC-02307: void can only be used when single parameter

Cause: A function can be declared or defined using the following syntax:

    int func1(void)

    to indicate that the function has no parameters. void can be used only once in this case.

Action: Remove the extra voids in the function definition or declaration.

##### PCC-02308: identifier required in this function definition

Cause: A function definition written in ANSI C must have both the name and the type for all parameters.

Action: Rewrite the function definition so that it contains the name of each parameter.

##### PCC-02309: illegal formal parameter declaration

Cause: A formal parameter in a function declaration was specified without giving its type.

Action: Rewrite the function declaration and include the types of all parameters in function declarations.

##### PCC-02310: formal parameter VARCHARs must be declared as pointers

Cause: Many C compilers allow structures to be passed to and returned from functions. Although a VARCHAR is implemented as a C struct, VARCHARs must be passed to a function as pointers.

Action: Take the address of a VARCHAR when it is passed to a function. See the example in the section "Referencing VARCHAR Variables" in the Programmer's Guide to the Oracle Precompilers.

##### PCC-02311: cannot have VARCHAR bit fields

Cause: Host variables cannot contain bit fields.

Action: Recode the application to remove the bit fields.

##### PCC-02312: arrays of VARCHAR greater than 2 dimensions not allowed

Cause: A VARCHAR array with more than two dimensions was declared. Multidimensional arrays are not supported as host variables.

Action: Recode the application to remove multidimensional array usage.

##### PCC-02313: malformed VARCHAR declaration - missing length

Cause: When a VARCHAR is declared, a length specification is mandatory. For example, the following VARCHAR declaration is meaningless, hence illegal:

    VARCHAR v1[];

Action: Specify the length for each declared VARCHAR.

##### PCC-02314: cannot evaluate constant SIZEOF expression

Cause: A SIZEOF operator was used where a precompiler expression was expected. For example, as the length of a VARCHAR.

Action: Eliminate the SIZEOF operator in this instance.

##### PCC-02315: cannot evaluate expression as a constant.

Cause: The specified expression does not evaluate to a constant. Such expressions are required, for example, as the length of a VARCHAR.

Action: Replace the expression with one that does evaluate to a constant integer.

##### PCC-02316: illegal operator in constant expression

Cause: A non-arithmetic operator was present in a constant expression.

Action: Rewrite the expression to eliminate the non-arithmetic operator.

##### PCC-02317: Illegal cast type expression

Cause: A illegal cast is present in the expression.

Action: Remove the illegal cast.

##### PCC-02318: missing type expression

Cause: The specified expression is missing the declaration of a type.

Action: Specify a type for the expression.

##### PCC-02319: expression type does not match usage

Cause: The type of a variable does not match its usage. For example, in dynamic SQL, a host variable containing the text of a SQL statement must be declared as a C character type or be equivalenced to the SQL type STRING.

Action: Remove the declaration.

##### PCC-02320: arithmetic expression does not have correct operand types

Cause: The arithmetic expression must be specified with integral types.

Action: Rewrite the expression using integral types.

##### PCC-02321: only subtraction between two pointers is permitted

Cause: Pointer values cannot be added, multiplied, or divided. The only arithmetic operation permitted with pointers is subtraction.

Action: Recode to avoid this error message.

##### PCC-02322: found undefined identifier

Cause: An identifier used in a SQL statement was not defined. For example, a cursor name was referenced that had not been declared, or in a DECLARE CURSOR statement, a statement name was used that had not been PREPAREd.

Action: Check that all SQL identifiers, such as cursor names and statement names, have been defined before use.

##### PCC-02323: found typedef name used in an expression (expecting a value)

Cause: The name of a typedef was found where a variable was expected.

Action: Rewrite the expression and remove the reference to the typedef.

##### PCC-02324: found variable name used as a typedef name

Cause: The name of a variable was found where a typedef was expected.

Action: Rewrite the expression and specify the correct typedef reference.

##### PCC-02325: illegal indirection operation

Cause: An attempt was made to use a non-pointer type as a pointer.

Action: Rewrite the expression.

##### PCC-02326: illegal structure reference operation

Cause: A structure component using invalid syntax was referenced. For example, a -> operator was used instead of a required `.' operator.

Action: Correct the invalid reference.

##### PCC-02327: struct or struct pointer required

Cause: A scalar host variable was used in a context where a structure (or its pointer) is required.

Action: Make the host variable a structure or add more scalar host variables to satisfy the SQL syntax requirements.

##### PCC-02328: undefined struct member

Cause: A structure component was referenced that was not declared as part of the structure.

Action: Redefine the structure member.

##### PCC-02329: found reference to undeclared function

Cause: A function was referenced that was not declared. All function references must be declared.

Action: Declare the function.

##### PCC-02330: expecting an expression of integer type

Cause: The expression does not evaluate to an integer. For example, a SQL FOR expression must evaluate to an integral type.

Action: Rewrite the expression.

##### PCC-02331: undefined SQL identifier

Cause: All SQL identifiers must be defined before they are used. This message can result when a CURSOR or STATEMENT is not declared (defined) before being referenced.

Action: Define the SQL identifier before it is used.

##### PCC-02332: attempted to redefine SQL identifier

Cause: A SQL identifier (such as a cursor name) can be defined only once.

Action: Do not redefine the SQL identifier. Use a different name.

##### PCC-02333: SQL identifier was not declared as a statement

Cause: A SQL statement identifier was referenced in a DECLARE... CURSOR statement that was not PREPAREd.

Action: Check that all SQL statement names have been declared. Remember that SQL statement names are identifiers, not variables, and that they are local to the precompilation unit.

##### PCC-02334: SQL identifier was not declared as a cursor

Cause: A cursor name was used in an OPEN, FETCH, or CLOSE statement that had not been DECLAREd.

Action: Check that all SQL cursor names have been declared. Remember that cursors are identifiers, not variables, and that they are local to the precompilation unit.

##### PCC-02335: body of cursor must name statement identifier

Cause: In a Dynamic SQL Method 4 application, the DECLARE... CURSOR statement must name a statement identifier that has been PREPAREd in a preceding statement. The PREPARE statement must physically (not logically) precede the DECLARE command.

Action: This error message is followed by another message that gives the line and column of the reference to the statement. Recode the application.

##### PCC-02336: host variable expression has invalid type

Cause: The host variable was declared using a C type that is not permitted as a host variable. See the Programmer's Guide to the Oracle Precompilers for a list of the permissible C types for host variables.

Action: Use a permissible host variable type.

##### PCC-02337: cannot declare multi-dimensioned array for this type

Cause: Host variable arrays of scalars with more than 1 dimension cannot be declared. The only host variables allowed to be multi-dimensioned are CHAR and VARCHAR.

Action: Recode the application because this kind of host variable usage is not possible with database operations.

##### PCC-02338: structure contains a nested struct or union

Cause: A structure used as a host variable may not have structures or unions nested within it.

Action: Rewrite the variable declaration.

##### PCC-02339: host variables cannot be of union types

Cause: A C union as a host variable cannot be used.

Action: This error message is followed by another message that gives the line and column of the reference to the illegal union. Recode, using a struct or individual scalar host variables.

##### PCC-02340: structure contains a bit field

Cause: Bit fields are not allowed in host variables because they are meaningless for database DML operations.

Action: This error message is followed by another message that gives the line and column of the reference to the offending host variable. Recode the application.

##### PCC-02341: host variable has illegal type

Cause: A host variable has an unpermitted type (i.e.; enum, void, etc).

Action: Rewrite the declaration, using a permissible host variable type.

##### PCC-02342: using WHERE CURRENT OF on cursor defined without FOR UPDATE clause

Cause: When MODE=Oracle, a cursor defined with a WHERE CURRENT OF clause must also have a FOR UPDATE clause.

Action: Rewrite the cursor definition.

##### PCC-02343: body of cursor must be a query expression

Cause: A cursor definition must be a SELECT statement.

Action: Rewrite the cursor definition.

##### PCC-02344: host variable array size mismatch. Using minimum: size

Cause: Host variable arrays in a single statement should all be of equal size.

Action: Redefine the bind variable array lengths to all be the same size.

##### PCC-02345: SQLCHECK=SEMANTICS must be given when embedded PL/SQL blocks are used

Cause: Embedded PL/SQL blocks require that the command-line flag SQLCHECK=SEMANTICS is used.

Action: Use the SQLCHECK=SEMANTICS option. This also requires that the USERID connect option be given.

##### PCC-02346: PL/SQL found semantic errors

Cause: A database entity, such as a table or column name, was referenced, that does not exist. This is a compile time error, not a runtime error.

Action: Check that all referenced objects in PL/SQL statements actually exist and that the necessary access permission on them have been granted.

##### PCC-02347: PL/SQL found syntax errors

Cause: A PL/SQL statement was used illegally.

Action: Check the PL/SQL User's Guide and Reference for the correct syntax.

##### PCC-02348: indicators are not allowed in EXEC IAF statements

Cause: Indicator variables associated with host variables cannot be used in EXEC IAF statements such as GET and PUT in a user exit.

Action: Eliminate the indicator variables. If feasible (for example with Forms V4), use EXEC TOOLS statements, which do allow indicator variables. See the Programmer's Guide to the Oracle Precompilers for more information of EXEC IAF and EXEC TOOLS statements.

##### PCC-02349: precision must be specified for this type

Cause: In a VAR or TYPE statement, certain Oracle types require that the precision be specified. For example, VARCHAR2 or CHAR.

Action: Indicate the precision.

##### PCC-02350: cannot equivalence this SQL type

Cause: Datatype or variable equivalencing to the datatypes NUMBER or DECIMAL cannot be used. See the "Datatype Equivalencing" section in the Programmer's Guide to the Oracle Precompilers for more information.

Action: Use the appropriate datatype for the application.

##### PCC-02351: illegal datatype equivalencing operation

Cause: The datatype specified could not be equivalenced, or the syntax was incorrect in the VAR or TYPE statement.

Action: See the Programmer's Guide to the Oracle Precompilers for a list of the datatypes that can be equivalenced and the correct syntax of the VAR or TYPE statement.

##### PCC-02352: out of bounds bind position from PL/SQL

Cause: PL/SQL requested a bind position that does not exist. This is an internal error.

Action: Call Oracle customer support for assistance.

##### PCC-02353: semantic error at line num, column colnam, file name

Cause: This error message precedes a more specific error message.

Action: No action required. Correct the error(s) reported in the following message(s).

##### PCC-02354: a file included with #INCLUDE cannot contain SQL statements

Cause: The Pro*C Precompiler reads header files referenced in #INCLUDE directives and uses the values defined in them. But the precompiler never generates code using statements in header files, so use of SQL statements in these files is illegal.

Action: Move the SQL statement(s) into the main body of the application or use EXEC SQL INCLUDE to check that the included file is precompiled.

##### PCC-02355: invalid or obsolete option, ignored

Cause: A command-line option that is not used in Pro*C Release 2.0 was specified. For example, the option AREASIZE is no longer valid with precompilers used with the Oracle Server.

Action: No action required. This is an informational message.

##### PCC-02356: Warning at line num, column colnam, file name

Cause: This is a generic warning message. It precedes a more specific warning.

Action: No action required. Correct the error(s) indicated in the following messages.

##### PCC-02357: function calls may not be used as host variable expressions

Cause: Only objects that are lvalues (that resolve to an address) can be host variables. Because a function call is not an lvalue, one cannot be used in place of a host variable.

Action: Recode the application.

##### PCC-02358: identifier following ARRAYLEN must be the name of an array

Cause: A declared array must be specified as the argument for an ARRAYLEN statement. Declare the array textually before the ARRAYLEN statement. See the Programmer's Guide to the Oracle Precompilers for the syntax of the ARRAYLEN statement.

Action: Correct the statement, specifying a host array as the argument.

##### PCC-02359: identifier specifying ARRAYLEN dimension must be a 4-byte integer

Cause: The expression that specifies the ARRAYLEN dimension must evaluate to an integer. For example, the statement

    EXEC SQL ARRAYLEN my_array(1.3)

    cannot be parsed.

Action: Correct the statement, using an integral dimension.

##### PCC-02360: this array type is invalid for use with ARRAYLEN statement

Cause: Arrays of some host variables types are not allowed and hence also cannot be used in ARRAYLEN statements. VARCHAR and DATE are examples.

Action: Specify an array with a datatype that can be used in host arrays.

##### PCC-02361: use of ARRAYLEN with SQL host arrays is ignored

Cause: ARRAYLEN is only valid with arrays that can be bound in PL/SQL blocks.

Action: Use an appropriate array type.

##### PCC-02362: host variable not declared within SQL Declare Section

Cause: When MODE=ANSI is specified at precompile time, all host variables must be declared inside Declare Sections. Remember that MODE=ANSI refers to ANSI SQL, not ANSI C.

Action: Add the EXEC SQL BEGIN DECLARE SECTION... EXEC SQL END DECLARE SECTION statements around all host variable declarations.

##### PCC-02363: indicator variable must be a structure

Cause: If the host variable is a structure, the associated indicator variable must also be a structure.

Action: Recode the application to create an indicator variable as a structure.

##### PCC-02364: host structure and its indicator must have the same number of fields

Cause: When a structure containing indicator variables is declared and associated with a host structure, the indicator structure must contain the same number of fields as the host structure. This is so even when some of the indicators will not be used or even when it would not make sense to do so (for fields constrained as NON NULL, for example).

Action: Redeclare the indicator variable with the correct number of fields.

##### PCC-02365: indicator array size cannot be smaller than host array size

Cause: An indicator array must have dimension greater than or equal to the corresponding host variable array dimension.

Action: Change the dimension of the indicator array.

##### PCC-02366: command line argument MODE=ANSI may not be used with DBMS=V6

Cause: The semantics of certain operations (such as character comparison) in Oracle Version 6 are not 100% compliant with the ANSI/ISO SQL standards. When V6 semantics are requested, using the DBMS=V6 or DBMS=V6_CHAR option, precompilation with MODE=ANSI is not permitted.

Action: Do not use ANSI mode with the V6 options.

##### PCC-02367: indicator variables must be declared as type short

Cause: The only C type allowed for indicator variables is short. An array of indicator variables must be an array of shorts.

Action: Redeclare the indicator variables and/or indicator arrays.

##### PCC-02368: an EXEC TOOLS host variable context name is not type char

Cause: If a host variable is used to define a context name in an EXEC TOOLS GET CONTEXT or EXEC TOOLS SET CONTEXT statement, the host variable must be a character type.

Action: Redeclare the context name to a host variable of a CHAR type.

##### PCC-02369: an EXEC TOOLS host pointer variable is not a pointer

Cause: The host variable specifying an EXEC TOOLS context must be a pointer type.

Action: Re-declare the variable, making sure that it is a pointer.

##### PCC-02370: an EXEC TOOLS MESSAGE host variable is not type char

Cause: If a host variable is used to define a context name in an EXEC TOOLS GET CONTEXT or EXEC TOOLS SET CONTEXT statement, the host variable must be a character type.

Action: Re-declare the message to a host variable of a char type.

##### PCC-02371: illegal FOR clause

Cause: The argument of a FOR clause must be specified as an integer or as an identifier containing an integer.

Action: Rewrite the FOR clause.

##### PCC-02372: FOR clause not allowed in a SELECT statement

Cause: A SQL statement containing a SELECT command cannot contain a FOR clause. The meaning of such a statement would be unclear.

Action: Rephrase the SELECT statement, removing the FOR clause.

##### PCC-02373: invalid declaration in EXEC SQL DECLARE section

Cause: An improper declaration was placed in a Declare Section. This message is usually caused by including an EXEC SQL TYPE or EXEC SQL VAR declaration in a Declare Section.

Action: Move the declaration outside the SQL DECLARE section.

##### PCC-02374: SQLCHECK value exceeds command line value

Cause: The value assigned to the SQLCHECK option in an EXEC ORACLE statement in a program was greater than the value given either on the command line or greater than the default value if no SQLCHECK option was given on the command line.

  The order of the option values is SEMANTICS > SYNTAX > NONE.

  When this warning message is issued, the original value of SQLCHECK (the default or the command-line value) stays in effect.

Action: Remove or recode the EXEC Oracle option(s) in the .pc source file to avoid this warning message.

##### PCC-02375: SQL statement found outside the body of a function

Cause: A SQL statement other than a declarative, datatype equivalence or WHENEVER statement was found outside the body of a function when PARSE=FULL.

Action: Move the SQL statement inside the body of a function.

##### PCC-02376: you may not declare SQLCODE when DEF_SQLCODE = TRUE

Cause: The DEF_SQLCODE option may not be specified if a SQLCODE declaration already explicitly appears in the program.

Action: Remove the SQLCODE declaration from the program or specify DEF_SQLCODE=NO (the default).

##### PCC-02377: arrays of implicit VARCHARs are not permitted

Cause: An array of implicit VARCHARs was declared when HOST_VARCHAR=TRUE.

Action: Rewrite the implicit VARCHAR declaration without using arrays.

##### PCC-02378: invalid type for National Language character variable

Cause: A variable declared as a National Language character using the NLS_CHAR option was not declared as a char or implicit VARCHAR.

Action: Declare the variable as a char or implicit VARCHAR or do not specify using the NLS_CHAR option.

##### PCC-02379: cannot equivalence National Language character variables

Cause: A National Language character variable (specified using the NLS_CHAR option) has undergone datatype equivalencing using either the EXEC SQL VAR or TYPE statements.

Action: Do not equivalence National Language character variables.

##### PCC-02382: you must specify MODE = ANSI when using NLS_CHAR

Cause: NLS_CHAR was used to specify NLS multi-byte character variables without specifying MODE=ANSI.

Action: Specify MODE=ANSI on the command line when using NLS_LOCAL=TRUE.

##### PCC-02384: missing array length specifier

Cause: An array declaration was given without an array length specifier.

Action: Provide the length for the array declaration.

##### PCC-02385: you may not specify DBMS = V6_CHAR when using NLS_CHAR

Cause: The DBMS=V6_CHAR option was specified on the command line while indicating which host variables are to be treated by the precompiler as NLS multi-byte character variables. A multi-byte character string must be null-terminated, but if the DBMS=V6_CHAR option is specified, the precompiler pads the character arrays with blanks up to the length of the array without the null-terminator.

Action: Remove the DBMS=V6_CHAR option from the command line.

##### PCC-02386: use of the AT clause is not permitted here

Cause: An explicit AT clause was used with an ALLOCATE statement or a FETCH/CLOSE statement also using a SQL_CURSOR declaration.

Action: Remove the AT clause.

##### PCC-02387: expecting an expression of type sql_cursor

Cause: A host bind variable was used in an ALLOCATE, FETCH or CLOSE statement that was not declared as a result set sql_cursor.

Action: Declare the variable to be of type sql_cursor.

##### PCC-02388: arrays not allowed in FROM/WHERE clause of SELECT statement

Cause: A host array was used in the WHERE clause of a SELECT-INTO statement.

Action: Rewrite the SELECT statement without using arrays or use a cursor.

##### PCC-02389: arrays not allowed as input bind variables in SELECT list

Cause: A host array was used in the SELECT list of a SELECT-INTO statement.

Action: Rewrite the SELECT statement without using arrays in SELECT list.

##### PCC-02390: no EXEC SQL CONTEXT USE statement encountered

Cause: No EXEC SQL CONTEXT USE statement was encountered and the option THREADS=YES was requested.

Action: Ensure that the necessary context variable (of type sql_context) has been declared and that has been ALLOCATEd and USEd prior to any executable SQL statements.

    Note:
    This error is only detected by Pro*C/C++ (beginning with release 2.2) and
    only if PARSE=FULL.

##### PCC-02391: runtime context variable not of correct type

Cause: The runtime context variable referenced in an EXEC SQL CONTEXT USE statement is not of type SQL_CONTEXT.

Action: Declare your runtime context to be of type SQL_CONTEXT.

##### PCC-02392: you are already in an EXEC SQL DECLARE SECTION

Cause: A SQL DECLARE SECTION appears nested inside another one.

Action: Do not nest DECLARE SECTIONS. Remove any nested inner ones.

##### PCC-02393: SQL statement found inside an EXEC SQL DECLARE SECTION

Cause: An executable SQL statement appears inside a DECLARE SECTION.

Action: Move the SQL statement into the body of a function.

##### PCC-02394: input file name and output filename are identical

Cause: The values of INAME and ONAME are the same, or the default output filename is the same as that specified by ONAME.

Action: Use ONAME to specify a different filename for the output file.

##### PCC-02395: using arrays of structs requires that the struct be named

Cause: An array of some unnamed struct was used as a host variable. When using arrays of structs, the struct requires a name or tag.

Action: Provide a name for the struct.

##### PCC-02396: illegal use of arrays inside an array of structs

Cause: An array of a struct that contained arrays of scalars or two-dimensional char or VARCHAR fields was used as a host variable.

Action: Rewrite the struct so that there are no scalar arrays or two-dimensional char or VARCHAR fields.

##### PCC-02397: VARCHAR declarations not permitted in #include file

Cause: A VARCHAR declaration was found in a file included using a #include form.

Action: Use the EXEC SQL INCLUDE form to include files with VARCHAR declarations instead.

##### PCC-02398: indicator ignored in this statement for this type

Cause: An indicator variable was used in a host/indicator variable pair for some type in a statement that did not require or need one. Typically, indicator variables are not used in ALLOCATE and FREE statements for types other than object or collection types. They are also not used in OBJECT CREATE/DEREF statements for REF types.

Action: Remove the use of the indicator for the type in the specified statement. It will be ignored otherwise.

##### PCC-02399: illegal CHAR_MAP option value for DBMS=V6. Option ignored

Cause: A CHAR_MAP option other than CHAR_MAP=VARCHAR2 was specified inline. Since DBMS=V6, this option is ignored for a character or string variable in the offending statement.

Action: Either set DBMS to something other than V6, or specify CHAR_MAP=VARCHAR2.

##### PCC-02400: this host variable must be declared as a pointer type

Cause: The specified host variable was not declared as a pointer type.

Action: Declare the host variable to be a pointer type.

##### PCC-02401: host variable arrays of this type are currently not supported

Cause: Host variable arrays of the specified type are not supported.

Action: Rewrite your program so that there are no arrays of this type.

##### PCC-02402: Pro*C option OBJECTS=YES is required when using the object cache

Cause: The object cache will be used for this host variable, but OBJECTS=NO was specified on the Pro*C command line.

Action: Specify OBJECTS=YES on the Pro*C command line when using the object cache.

##### PCC-02403: invalid indicator variable type for this host variable

Cause: The type of the indicator variable is not appropriate for the specified host variable.

Action: Change the type of the indicator variable to a valid type. Refer to the "Programmer's Guide to the ORACLE Pro*C/C++ Precompiler" for a discussion of appropriate indicator variable declarations.

##### PCC-02404: this indicator variable must be declared as a pointer type

Cause: The specified indicator variable was not declared as pointer type.

Action: Declare the indicator variable to be a pointer type.

##### PCC-02405: variable is of undefined type

Cause: No declaration was found for the type identifier of the variable.

Action: Provide a valid declaration for the type of the host variable. If using objects in your program, check that the OTT-generated header for the object type was #included and that the typefile was specified in the INTYPE option on the Pro*C command line.

##### PCC-02406: expecting the form 'RETURN[ING] REF INTO :<ref>' only

Cause: When using the RETURNING clause in an OBJECT CREATE statement, only a single 'REF INTO :<host variable>' is expected. This error occurs if the expression list to which REF belongs is greater than one or if there are more than one host variables supplied in the into list.

Action: Rewrite the RETURNING clause as per the given specification.

##### PCC-02407: object and REF types do not match

Cause: In an OBJECT CREATE or DEREF statement, the types of the given Object and its associated REF do not match.

Action: Make sure that the Object and its REF have the same type. The type information is generated by OTT and should appear in the header file which OTT creates.

##### PCC-02408: expecting an expression of some Object type

Cause: The expression is not an Object type. For example, many host variable expressions in the Navigational statements require that the variable be declared of some Object type.

Action: Rewrite the expression or declare the variable to be an Object.

##### PCC-02409: expecting an expression of some REF type

Cause: The expression is not a REF type. For example, some host variables in the Navigational CREATE and DEREF statements are required to be declared of some REF type.

Action: Rewrite the expression or declare the variable to be a REF.

##### PCC-02410: type of a Collections host variable must resolve to OCIColl

Cause: A bind variable for collections did not resolve to the type OCIColl.

Action: Check that the OTT-generated header for the collections type was properly #included in the Pro*C program and that the typefile was specified in the INTYPE option on the Pro*C command line.

##### PCC-02411: type of an Object REF host variable must resolve to OCIRef

Cause: A bind variable for object REF did not resolve to the type OCIRef.

Action: Check that the OTT-generated header for the object type was properly #included in the Pro*C program and that the typefile was specified in the INTYPE option on the Pro*C command line.

##### PCC-02412: FOR clause not permitted in OBJECT GET or SET statement

Cause: An explicit FOR clause was used in an OBJECT GET or OBJECT SET statement. Use of the FOR clause is illegal for these statements.

Action: Remove the FOR clause.

##### PCC-02413: number of attributes does not match number of host variables

Cause: The number of attributes supplied in the attribute list of an OBJECT SET of GET statement does not match the total number of host variables also supplied in that statement.

Action: Either remove some attributes or remove some host variables from the statement in order to make the total count for each the same.

##### PCC-02414: this attribute does not exist in the specified Object

Cause: An attribute given in the attribute list of an OBJECT SET or GET statement is not a member of the specified object in that statement.

Action: Remove the attribute from the list.

##### PCC-02415: cannot manipulate Object attributes in an OBJECT GET or SET

Cause: An attempt was made to either GET or SET an attribute of an Object that itself was an Object or REF type.

Action: Remove the attribute from the attribute list in the statement.

##### PCC-02416: the Object in an OBJECT GET or SET must not be an array

Cause: The Object specified in an OBJECT GET or SET statement is an array which is illegal.

Action: Redeclare the Object so that it is not an array or subscript the Object so that only a single element of the Object array is specified.

##### PCC-02417: illegal type conversion between attribute and host variable

Cause: An illegal type conversion was attempted in a Navigational GET or SET statement between the type of the Attribute and the type of the Host Variable.

Action: Change the type of either the Attribute or the Host Variable.

##### PCC-02418: array size mismatch between Object and REF host variables

Cause: The array sizes of the Object and REF variables in an OBJECT CREATE or DEREF do not match.

Action: Adjust the array dimensions of the two host variables so that they are equal to one another.

##### PCC-02419: host variable arrays not allowed in an OBJECT SET or GET

Cause: An array was found in the host variable list of an OBJECT SET or GET statement.

Action: Only scalars are allowed (except for single dimensioned char or varchar variables) in the host variable list of an OBJECT SET or GET. Make sure to use only scalars in these statements.

##### PCC-02420: incomplete (or missing) type specification

Cause: An incomplete or perhaps missing type specification was given when declaring a host variable used in some SQL statement.

Action: Provide a complete type definition when declaring host variables intended for use inside any SQL statements.

##### PCC-02421: this host variable requires the use of an indicator variable

Cause: No indicator variable was provided (or matched) with a specific host variable where one was explicitely required.

Action: Provide an indicator variable for use with the specified host variable in the given SQL statement.

##### PCC-02422: invalid value specified for the given context option

Cause: An illegal value was given for the specified runtime context option in the CONTEXT <option> OPTION SET (or GET) statement.

Action: Use a valid option value in the statement for the specified option being manipulated by the statement.

##### PCC-02423: host variable has an invalid type for this option value

Cause: The type of the host variable corresponding to a specific option value in a CONTEXT <option> OPTION SET (or GET) statement is invalid for that particular value.

Action: Use a type suitable for the specific value being manipulated.

##### PCC-02424: the number of values and host variables does not match

Cause: There is a mismatch between the number of values specified and the number of valid host variables given in a CONTEXT <option> OPTION SET (or GET) statement.

Action: Use the same number of host variables as there are values given in that particular statement.

##### PCC-20113: DBMS=V6 no longer supported; using DBMS=NATIVE, CHAR_MAP=VARCHAR2

Cause: DBMS=V6 was specified on the command line, but is no longer a supported option value. The options DBMS=NATIVE and CHAR_MAP=VARCHAR2 were used instead.

Action: Check your program to verify that you are not depending on any V6 behavior. Please refer to the Programmer's Guide to the Pro*C/C++ Precompiler for effects of specifying DBMS=V6.

##### PCC-20114: command line argument MODE=ANSI may not be used with DBMS=V6

Cause: The semantics of certain operations (such as character comparison) in Oracle version 6 are not 100% compliant with the ANSI/ISO SQL standards. When V6 semantics are requested, using the DBMS=V6 or DBMS=V6_CHAR option, precompilation with MODE=ANSI is not permitted.

Action: Do not use ANSI mode with V6 options.

Prev | Top | Next
| Copyright © 1997 Oracle Corporation. All Rights Reserved. |
Library | Product | Contents | Index