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

Question Posted / guest

1 Answers
3148 Views
I also Faced
E-Mail Answers

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

RMAN-06545: "string" is an invalid response - please re-enter.

1 Answers

ORA-12650: No common encryption or data integrity algorithm

1 Answers

TNS-04202: Trace Assistant Usage ERROR: Not enough arguments

1 Answers

PCC-02341: host variable has illegal type

1 Answers

ORA-00203: using the wrong controlfiles

1 Answers

ORA-19594: controlfile already included as string

1 Answers

ORA-27546: Oracle compiled against IPC interface version string.string found version string.string

1 Answers

ORA-09344: spsig: error signalling thread

1 Answers

QSM-02036: in-list present in mv

1 Answers

TNS-01402: TYPE: string

1 Answers

NZE-29194: no CRL found in cache

1 Answers

ORA-14282: FOREIGN KEY constraint mismatch in ALTER TABLE EXCHANGE SUBPARTITION

1 Answers

For more Oracle Errors Interview Questions Click Here