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;


Start Free Trial