SQL-02144: Invalid ANSI dynamic usage



SQL-02144: Invalid ANSI dynamic usage..

Answer / guest

Cause: An ANSI allocate, deallocate, get or set descriptor
statement was encountered when dynamic option was not set.

Action: Precompile your source with option dynamic=ansi.

Please add more information about this Error

Is This Answer Correct ?    0 Yes 0 No

Post New Answer

More Oracle Errors Interview Questions

NZE-29189: No entry found in OID

1 Answers  


ORA-29909: label for the ancillary operator is not a literal number

1 Answers  


ORA-12985: tablespace 'string' is read only, cannot drop column

1 Answers  


ORA-01804: failure to initialize timezone information

2 Answers  


UDE-00014: invalid value for parameter, 'string'.

1 Answers  






ORA-01246: recovering files through TSPITR of tablespace string

1 Answers  


ORA-01954: DEFAULT ROLE clause not valid for CREATE USER

1 Answers  


ORA-31498: description and remove_description cannot both be specified

1 Answers  


LFI-01517: open() failed(OSD return value = string).

1 Answers  


NID-00103: Missing password in connect string "string"

1 Answers  


ORA-30690: timeout occurred while registering a TCP/IP connection for data traffic detection

1 Answers  


ORA-01967: invalid option for CREATE CONTROLFILE

3 Answers   Oracle,


Categories