Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: calling external C function from oracle

Re: calling external C function from oracle

From: Jim Kennedy <kennedy-downwithspammersfamily_at_attbi.net>
Date: Fri, 29 Oct 2004 03:42:05 GMT
Message-ID: <h_igd.436931$mD.269371@attbi_s02>

"Satish" <satishsanthanam_at_yahoo.com> wrote in message news:d04d15e8.0410281917.39071764_at_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

As a side note I would specify the date
format.TO_DATE('29-OCT-2004','dd-mmm-yyyy'), It looks like you are missing a /
Jim Received on Thu Oct 28 2004 - 22:42:05 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US