Skip to Main Content

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.

Error loading external library

DrBugsDec 15 2006
Error loading external library

I am trying to work with a C routine called in Pl/Sql.

When i run the program i encounter the following error.

nimsD2>exec nim_orders.pr_process_orders;
begin nim_orders.pr_process_orders; end;

*
ERROR at line 1:
ORA-06520: PL/SQL: Error loading external library
ORA-06522: ld.so.1: extprocepsid_nims: fatal: libclntsh.so.8.0: open failed: No such file or
directory
ORA-06512: at "NIMS.NIMK_SEND_MAIL", line 0
ORA-06512: at "NIMS.NIM_ORDERS", line 81
ORA-06520: PL/SQL: Error loading external library
ORA-06522: ld.so.1: extprocepsid_nims: fatal: libclntsh.so.8.0: open failed: No such file or
directory
ORA-06512: at line 1

From Oracle Help;
ORA-06520: PL/SQL: Error loading external library
Cause: An error was detected by PL/SQL trying to load the external library dynamically.
Action: Check the stacked error (if any) for more details.

LIBRARY MQCANCELORDER and it's path is already present in all_libraries.

===============================================================================================

CREATE OR REPLACE PACKAGE BODY nim_orders
AS
PROCEDURE pr_process_orders
IS

:
:
BEGIN
:
:
lvReturnValue := fn_call_C_proc(recQueueInfo.queue_manager_name, recQueueInfo.get_queue_name, lvreceivedMsg);

:
:
End;

FUNCTION fn_call_C_proc(p_queue_manager_name IN VARCHAR2
,p_queue_name IN VARCHAR2
,p_received_msg OUT VARCHAR2
)
RETURN BINARY_INTEGER
AS
EXTERNAL
LIBRARY MQCANCELORDER
NAME "processCancelledOrders"
Language C
WITH CONTEXT
PARAMETERS(CONTEXT,
p_queue_manager_name,
p_queue_manager_name INDICATOR SHORT,
p_queue_name,
p_queue_name INDICATOR SHORT,
p_received_msg,
p_received_msg INDICATOR SHORT
);
END fn_parse_cancelled_order;
End nim_orders;

Comments

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

Post Details

Locked on Jan 12 2007
Added on Dec 15 2006
0 comments
307 views