ORA-06539: target of OPEN must be a query



ORA-06539: target of OPEN must be a query..

Answer / guest

Cause: The program attempted to perform an OPEN cursor
operation on a dynamic statement that was not a query.

Action: Ensure that the OPEN cursor operation is done on a
dynamic query statement.
--------------------------------------------------------
06540 through 06549 reserved for pl/sql error handling

Please add more information about this Error

Is This Answer Correct ?    0 Yes 0 No

Post New Answer

More Oracle Errors Interview Questions

ORA-02189: ON <tablespace> required

1 Answers  


ORA-01611: thread number string is invalid - must be between 1 and string

1 Answers  


QSM-02142: COUNT(*) is not present in the select list

1 Answers  


SQL*Loader-00600: Bind size of number bytes increased to number bytes to hold 1 row.

1 Answers  


ORA-01906: BACKUP keyword expected

1 Answers  






ORA-23448: duplicate user parameter value

1 Answers  


TNS-01153: Failed to process string: string

1 Answers  


ORA-31668: Timeout before worker process string finished initialization.

1 Answers  


ORA-24182: attribute number specified does not exist

1 Answers  


PLS-00389: table, view or alias name "string" not allowed in this context

1 Answers  


ORA-31016: Attempted to delete entry without name

1 Answers  


ORA-01660: tablespace 'string' is already permanent

1 Answers  


Categories