Skip to Main Content
Forums

SQL & PL/SQL

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!

Interested in getting your voice heard by members of the Developer Marketing team at Oracle? Check out this post for AppDev or this post for AI focus group information.

ORA-06522: cannot dynamically load executable

654443Aug 11 2008 — edited Aug 11 2008
Hi,

I am able to compile and link my external procedure in C using OCI successfully
But when i try to use it from sqlplus. I am getting the following error.

ORA-06520: PL/SQL: Error loading external library
ORA-06522: /usr/lib/oracle/xe/app/oracle/product/10.2.0/server/lib/custagg.so:
cannot dynamically load executable

Was PLSQL able to locate my extproc or not.

If it is locating the extproc custagg.so , how can i know where it is failing.

Can you please tell me how I can debug my extproc. I mean How to install debug_extproc package .. i tried looking out for dbgextp.sql file inorder to install that package but did not find it anywhere..

Please kindly answer my queries and also please let me know how i can install and use DEBUG_EXTPROC in PLSQL under Linux 32 bit server machine.

when i run the DEBUG_EXTPROC startup related command i am getting an error ...undeclared identifier..

Please reply to this post.

Thanks,
-NN

Comments

Locked Post
New comments cannot be posted to this locked post.

Post Details

Locked on Sep 8 2008
Added on Aug 11 2008
1 comment
172 views