Re: calling external C function from oracle

From: Manfred Peter (Alligator Company) <m.peter_at_alligatorsql.de>
Date: Fri, 29 Oct 2004 15:04:12 +0200
Message-ID: <cltf8n$v1i$01$1@news.t-online.com>

Hello Satish,

it looks like Oracle miss the extproc process or the path in the tnsname os not correct (for extproc).

Hope this helps ?

-- 
Manfred Peter
Alligator Software Company GmbH
Schulstraße 121a
D-27726 Worpswede



Satish wrote:



>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 Fri Oct 29 2004 - 08:04:12 CDT