Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Extended Stored Procedures

392900Apr 21 2003 — edited Apr 23 2003

Hi pros,
System - oracle 9i on HP-UX 11.22

I have written an extended stored procedure in the db, which points to a function in a shared library. That function tries to insert some data into the database.
In this scenario, I face two problems:

Issue #1.Without making an explicit oracle connection in the Shared library, it does not work.
This doe not make any sense to me. When I call the ESP from the SQL propmt, why should it ask for db connection again? I am sure I am wrong with something.

Issue #2.If I try to log something into a file from the shared library, the process aborts giving the following error:
ORA-28576: lost RPC connection to external procedure agent

Please throw some light in to these issues.

Thanks
Ganesh

Locked Post

New comments cannot be posted to this locked post.

Locked on May 21 2003

Added on Apr 21 2003

#general-database-discussions

1 comment

315 views