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

NZE-28785: parameter does not exist

1 Answers  


PCC-02393: SQL statement found inside an EXEC SQL DECLARE SECTION

1 Answers  


LCD-00219: nested include file [string] is too large

1 Answers  


ORA-06319: IPA: Remote maximum number of users exceeded

1 Answers  


ORA-25176: storage specification not permitted for primary key

1 Answers  






ORA-07741: slemop: $OPEN failure

1 Answers  


PROT-00006: The specified import file cannot be found

1 Answers  


ORA-30153: An invalid File Object is passed to the OCIFile function

1 Answers  


EXP-00097: Object type "string"."string" is not in a valid state, type will not be exported

2 Answers  


ORA-03275: duplicate DEALLOCATE option specification

1 Answers  


ORA-29933: object being disassociated has some user defined statistics stored

1 Answers  


ORA-14048: a partition maintenance operation may not be combined with other operations

1 Answers  


Categories