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

PCC-02420: Incomplete (or missing) type specification

1 Answers  

---

ORA-01918: user 'string' does not exist

1 Answers  

---

ORA-29365: parameters string and string cannot both be set

1 Answers  

---

PLS-01710: In a positioned DELETE or UPDATE statement, the cursor name must be of length 1

1 Answers  

---

SQL*Loader-00963: Error clearing user-side Ctrl-C handler

1 Answers  

---

ORA-16730: Error executing dbms_logstdby.skip_txn procedure

1 Answers  

---

NZE-28770: Data source is already initialized.

1 Answers  

---

ORA-00338: log string of thread string is more recent than controlfile

1 Answers  

---

ORA-14032: partition bound of partition number string is too high

1 Answers  

---

TNS-12558: TNS:protocol adapter not loaded

1 Answers  

---

ORA-06134: NETTCP: file access privilege violation

1 Answers  

---

DRG-12018: Encountered an automatic request for changing proxy - continue?

1 Answers  

---