Home » RDBMS Server » Server Administration » ORA-00023 (oracle 10.2.0.3)
ORA-00023 [message #308106] Fri, 21 March 2008 03:46 Go to next message
Haler
Messages: 71
Registered: October 2004
Member
Hello,

Can you explain the ORA-00023 error in execution of program developed under windev11 with native access oracle?
Execution crashes.
There are 2 sessions generated by the program, but one can be traced.

Thank's in advance.
Re: ORA-00023 [message #308108 is a reply to message #308106] Fri, 21 March 2008 03:49 Go to previous messageGo to next message
Michel Cadot
Messages: 68718
Registered: March 2007
Location: Saint-Maur, France, https...
Senior Member
Account Moderator
ORA-00023: session references process private memory; cannot detach session
 *Cause:  An attempt was made to detach the current session when it contains
          references to process private memory.
 *Action: A session may contain references to process memory (PGA) if it has
          an open network connection, a very large context area, or operating
          system privileges.  To allow the detach, it may be necessary to
          close the session's database links and/or cursors.  Detaching a
          session with operating system privileges is always disallowed.

Regards
Michel
Re: ORA-00023 [message #308110 is a reply to message #308108] Fri, 21 March 2008 04:00 Go to previous messageGo to next message
Haler
Messages: 71
Registered: October 2004
Member
I know the content of erreur but what is the cause.
Problem layer OIC third Windev or Oracle?
The trace of the session does not specify error.
How to be aware of the location of the crash?
Re: ORA-00023 [message #308111 is a reply to message #308106] Fri, 21 March 2008 04:01 Go to previous messageGo to next message
Haler
Messages: 71
Registered: October 2004
Member
excuse me read OCI and not OIC.
Re: ORA-00023 [message #308114 is a reply to message #308110] Fri, 21 March 2008 04:11 Go to previous messageGo to next message
Michel Cadot
Messages: 68718
Registered: March 2007
Location: Saint-Maur, France, https...
Senior Member
Account Moderator
I think you have to open a SR.
The only issues reported with this error in Metalink are for Oracle version 7.

Regards
Michel

[Edit: missing "s"]

[Updated on: Fri, 21 March 2008 05:24]

Report message to a moderator

Re: ORA-00023 [message #308119 is a reply to message #308114] Fri, 21 March 2008 04:58 Go to previous message
Haler
Messages: 71
Registered: October 2004
Member
Thank you for your speedy response
Previous Topic: oracle 9i installation
Next Topic: Storage Options
Goto Forum:
  


Current Time: Mon Dec 02 03:39:38 CST 2024