SQL-02150: Encountered zero length in ANSI dynamic SET statement



SQL-02150: Encountered zero length in ANSI dynamic SET statement..

Answer / guest

Cause: An invalid length of zero was encountered in an ANSI
dynamic statement.

Action: Set the length to a non-zero value

Please add more information about this Error

Is This Answer Correct ?    0 Yes 0 No

Post New Answer

More Oracle Errors Interview Questions

PLS-00902: A READ-ONLY bind variable used in OUT or IN-OUT context

1 Answers  


SQL*Loader-00116: Error prompting for password

1 Answers  


TNS-00084: * trace_off - ask process name to turn tracing off

1 Answers  


ORA-26685: cannot apply transactions from multiple sources

1 Answers  


PLS-00712: illegal option for subprogram string

1 Answers  






ORA-30555: global index partitioning key is an expression

1 Answers  


NNL-00540: [show] status [<server_list>] : display server status summary

1 Answers  


ORA-02075: another instance changed state of transaction string

1 Answers  


ORA-28232: invalid input length for obfuscation toolkit

1 Answers  


RMAN-06525: RMAN retention policy is set to none

1 Answers  


RMAN-06722: unable to remove file "string" from catalog

1 Answers  


QSM-01087: query grouping on a column that cannot be derived from materialized view, string

1 Answers  


Categories