Error loading external library
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;