calling external C function from oracle

From: Satish <satishsanthanam_at_yahoo.com>
Date: 28 Oct 2004 20:17:19 -0700
Message-ID: <d04d15e8.0410281917.39071764@posting.google.com>

Hi All,

I get the below error when my procedure tries to call external procedure. Any idea regarding this error. I have the library libtls4d.so and the path of it is specified in LD_LIBRARY_PATH>

SQL> DECLARE
  2 "ret" NUMBER;
  3 BEGIN
  4 "ret" := credit.pa_dbanalytics.get_dirty_for_clean('11192115',TO_DATE('29-OCT-2004'),100);   5 EXCEPTION
  6 WHEN OTHERS THEN
  7 NULL;
  8 RAISE;
  9 END;
10 /
DECLARE
*
ERROR at line 1:
ORA-06520: PL/SQL: Error loading external library ORA-06522: ld.so.1: /ug001/oracle/8.0.5/bin/extprocCALLOUT: fatal: libtls4d.so: open failed: No such file or directory ORA-06512: at line 8

Thanks and Regards,
Satish Received on Thu Oct 28 2004 - 22:17:19 CDT