PCC-00117: Invalid ARRAYLEN length variable type



PCC-00117: Invalid ARRAYLEN length variable type..

Answer / guest

Cause: A valid array dimension was not specified in an
ARRAYLEN statement. The array 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); --
illegal dimension

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

Please add more information about this Error

Is This Answer Correct ?    0 Yes 0 No

Post New Answer

More Oracle Errors Interview Questions

ORA-36871: (XSFTDSC01) Object string cannot be used to define a column in a LIMITMAP.

1 Answers  


ORA-09708: soacon: failed to bind socket to port.

1 Answers  


ORA-22853: invalid LOB storage option specification

1 Answers  


ORA-08445: syntax error in SIGN clause in mask options

1 Answers  


ORA-38483: invalid FUNCTION/PACKAGE/TYPE name: "string"

1 Answers  


NNL-00907: NOT ALLOWED responses sent: number

1 Answers  


ORA-08102: index key not found, obj# string, file string, block string (string)

1 Answers  


ORA-30002: SYS_CONNECT_BY_PATH function is not allowed here

1 Answers  


ORA-23403: refresh group "string"."string" already exists

1 Answers  


ORA-16539: task element not found

1 Answers  


ORA-16075: standby database destination mismatch

1 Answers  


ORA-02397: exceeded PRIVATE_SGA limit, you are being logged off

1 Answers  


Categories