calling external procedure

Hi all,
my env: ocracle 9.2.0.3/linux/gcc2.96
My oci app's ocistmtexecute() always gets above err(desp: 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)
while calling an external procedure(C code) from a pl/sql annoymous block like this:
begin :return:=extpack.testextproc(...); end; The ext procedure is built with "-shared -fPIC". Same app yet ocistmtexecute() without calling ext proc has no problems.

Any clues?

Many thanks

-matt Received on Tue Oct 28 2003 - 18:57:27 CST