PCC-00064: All uses of a given host variable must use identical indicator variables
Cause: Two or more occurrences of a host variable in an EXEC SQL statement were associated with different indicator variables. This is not allowed.
Action: Rename the indicator variables so that each occurrence of the host variable is associated with the same indicator variable.
PCC-00063: Reached end of file string before End-of-Statement at line number!
Cause: The precompiler encountered an end-of-file while parsing a PL/SQL block.
Action: Add the appropriate statement terminator (;) or end-of-block statement (END;) to the PL/SQL block.
PCC-00062: 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.
PCC-00061: Error at line number, column number. PLS-number: string
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.
PCC-00060: Both CURSOR and STATEMENT have AT clauses at line number of file string
Cause: Two AT clauses, one in a DECLARE STATEMENT statement, the other in a DECLARE CURSOR statement, pertain to the same SQL statement. The AT clause may be specified with either DECLARE STATEMENT or DECLARE CURSOR, but not with both.
Action: Remove the AT clause from one of the statements.
PCC-00056: FOR clause not allowed on SELECT statement at line number in file string
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.
PCC-00055: Array "string" not allowed as bind variable at line number in file string
Cause: A host array was used as a bind (input) variable in the WHERE clause of a SELECT statement. This is not allowed.
Action: Remove the host array or replace it with a simple host variable.
PCC-00054: Expected End-of-Statement at column number in line number of file string
Cause: The precompiler expected to find a statement terminator at the end of an EXEC statement but found something else. This can happen if tabs were embedded in the source code (because the precompiler has no way of knowing how many spaces a tab represents).
Action: If tabs are embedded in the source code, replace them with spaces. Check the statement syntax and check that each EXEC statement has a terminator. For embedded CREATE {FUNCTION | PROCEDURE | PACKAGE} statements and for embedded PL/SQL blocks, check that the statement terminator is END-EXEC.
PCC-00053: FOR variable string is invalid type at line number in file string
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).
PCC-00051: Size of VARCHAR string is larger than 65533 in line number in file string
Cause: The declared size of a VARCHAR host variable exceeds the precompiler limit of 65533 bytes.
Action: Check the DECLARE section, making sure the size of each VARCHAR variable does not exceed the limit of 65533 bytes.