ORA-01042: detaching a session with open cursors not allowed



ORA-01042: detaching a session with open cursors not allowed..

Answer / guest

Cause: An attempt was made to detach a seesio n which had
open cursors.

Action: Close all the cursors before detaching the session.

Please add more information about this Error

Is This Answer Correct ?    0 Yes 0 No

Post New Answer

More Oracle Errors Interview Questions

ORA-01126: database must be mounted in this instance and not open in any instance

1 Answers  


ORA-28292: No Domain Policy registered for Kerberos based authentication

1 Answers  


PLS-00660: SELF parameter of constructor method must be IN OUT

1 Answers  


ORA-13366: invalid combination of interior exterior rings

1 Answers  


ORA-25103: NOPARALLEL option can only be used with ALTER INDEX REBUILD

1 Answers  






TNS-12607: TNS: Connect timeout occurred

1 Answers  


RMAN-08011: including current controlfile in backupset

1 Answers  


PLS-00237: invalid BY VALUE indicator or length specification

1 Answers  


ORA-39952: only numbers can be specified as range values

1 Answers  


PLS-00648: type of supertype attribute "string" can not be a subtype or reference to a subtype in this release

1 Answers  


ORA-00202: controlfile: 'string'

1 Answers  


ORA-24786: separated transaction has been completed

1 Answers  


Categories