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

RMAN-06563: controlfile or SPFILE must be restored using FROM AUTOBACKUP

1 Answers  


PLS-00528: The parameters to an ORDER function must have IN mode

1 Answers  


ORA-27064: cannot perform async I/O to file

1 Answers  


ORA-02728: osnfop: access error on oracle executable

1 Answers  


ORA-39302: schema clone operation failed

1 Answers  






DRG-13102: index partition name must be specified

1 Answers  


PLS-01906: : raw variable length too long

1 Answers  


SQL*Loader-00607: partition not empty for INSERT option; table string, partition string

1 Answers  


ORA-14631: the partition bounds do not match the subpartition bounds of the partition

1 Answers  


ORA-16046: Archive log destination failed due to failed dependent destination

1 Answers  


ORA-19554: error allocating device, device type: string, device name: string

1 Answers  


QSM-01103: there is a remote table, string, referenced in the query

1 Answers  


Categories