ORA-01485: compile bind length different from execute bind
length



ORA-01485: compile bind length different from execute bind length..

Answer / guest

Cause: You bound a buffer of type DTYVCS (VARCHAR with the
two byte length in front) and at execute time the length in
the first two bytes is more than the maximum buffer length
(given in the bind call). The number of elements in the
array and the current number of elements in the array cannot
be more than the maximum size of the array.

Action: none

Please add more information about this Error

Is This Answer Correct ?    1 Yes 1 No

Post New Answer

More Oracle Errors Interview Questions

PLS-00318: type "string" is malformed because it is a non-REF mutually recursive type

1 Answers  


ORA-19757: could not resize change tracking file to string blocks

1 Answers  


PLS-01403: Comment delimiters /* */

1 Answers  


ORA-12620: TNS:requested characteristic not available

1 Answers  


ORA-38604: FI including & excluding cursor item-id type must match input cursor item-id type

1 Answers  






ORA-33290: (DBERR17) Analytic workspace string cannot be attached in the mode you requested because another user has it attached in an incompatible mode.

1 Answers  


RMAN-07501: searching for all files in the recovery area

1 Answers  


ORA-01062: unable to allocate memory for define buffer

1 Answers  


PLS-00230: OUT and IN OUT formal parameters may not have default expressions

1 Answers  


ORA-09353: Windows 32-bit Two-Task driver unable to open event semaphore

1 Answers  


NNL-00342: Log file name is currently string

1 Answers  


RMAN-07522: CREATE TYPE privilege must be granted to user string

1 Answers  


Categories