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

NMP-00011: internal SNMP program interface error

1 Answers  

---

ORA-16803: Unable to query a database table or fixed view.

2 Answers  

---

ORA-38104: Columns referenced in the ON Clause cannot be updated: string

1 Answers  

---

NZE-29163: Third party PKI vendor is not supported in FIPS mode.

1 Answers  

---

ORA-12571: TNS:packet writer failure

1 Answers  

---

QSM-01084: materialized view, string, has anchor, string, not found in query

1 Answers  

---

ORA-08180: no snapshot found based on specified time

1 Answers  

---

ORA-30190: reserved for future use

1 Answers  

---

ORA-12707: error while getting create database NLS parameter string

1 Answers  

---

ORA-00205: error in identifying controlfile, check alert log for more info

2 Answers   TechValley,

---

ORA-01229: data file string is inconsistent with logs

1 Answers  

---

ORA-24076: cannot perform operation string for NON_PERSISTENT queue string.string

1 Answers  

---