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-29552: verification warning: string

1 Answers  


ORA-02787: Unable to allocate memory for segment list

1 Answers  


TNS-12520: TNS:listener could not find available handler for requested type of server

1 Answers  


ORA-15065: hash collision for diskgroup names 'string' and 'string'

1 Answers  


PCC-00038: Unable to open a cursor

1 Answers  


ORA-31052: Cannot delete ACL with other references

1 Answers  


ORA-38712: Corrupt flashback log record header: block string, offset string.

1 Answers  


ORA-31083: error while creating SQL type "string"."string"

1 Answers  


ORA-06760: TLI Driver: timeout reading orderly release

1 Answers  


PLS-00636: overriding method requires OVERRIDING keyword

1 Answers  


ORA-08263: ora_addr: cannot free listener address

1 Answers  


PCB-00200: Cannot equivalence PIC N or PIC G variable "string"

1 Answers  


Categories