PCB-00235: Table size mismatch in INTO/USING. Minimum is: number
Answer / guest
Cause: The size of a table variable in an INTO/USING clause
of a dynamic EXECUTE statement has been ARRAYLEN...EXECUTE'd
while the other host variable has not and is not a table of
dimension 1 or a plain non-table host variable. Example: 01
X PIC X(10) OCCURS 10. 01 Y PIC S9(4) COMP OCCURS 10. 01 Z
PIC S9(4) COMP. ... EXEC SQL ARRAYLEN X (DIM) EXECUTE
END-EXEC. ... EXEC SQL EXECUTE S1 USING :X, :Y END-EXEC. <--
error EXEC SQL EXECUTE S1 USING :X, :Z END-EXEC. <-- ok
Please note that this error differs from 233 in that it is
an ERROR not a WARNING.
Action: ARRAYLEN...EXECUTE all of the table variables in the
INTO/USING clause or those host variables not
ARRAYLEN...EXECUTEd need to be of dimension 1.
Please add more information about this Error
| Is This Answer Correct ? | 0 Yes | 0 No |
ORA-36714: (XSMXALLOC03) TARGETLOG variable workspace object must have the same data type as TARGET variable workspace object.
TNS-01064: Listener configuration changes will not be persistent
IMG-00607: unable to write to destination image
ORA-13901: Object string was not found.
ORA-24129: table name string does not start with string prefix
ORA-28651: Primary index on IOTs can not be marked unusable
SQL*Loader-00103: Invalid log file name on command line
PCC-00050: Unable to generate descriptor in program unit ending line number in file string
NNL-00413: Total response time: string
ORA-30386: invalid SQL statement for DECLARE_REWRITE_EQUIVALENCE
ORA-32587: Cannot drop nonexistent string supplemental logging
TNS-02521: encryption/crypto-checksumming: Diffie-Hellman seed too small