Re: Fwd: Extproc problem...

"Khedr, Waleed" wrote:
>
> Try: ld -m /data1/dev/uexit/test/extproc.so
>
> -----Original Message-----
> Sent: Sunday, November 18, 2001 10:45 PM
> To: Multiple recipients of list ORACLE-L
>
> Hi,
> Pl use the equivalent of DLL walker of NT in Unix to find the exact name of
> the shared object that you have created. The shared object created by you
> will have some name appended during the compilation of the program. Pl use
> this name and ref the same in Oracle.
>
> HTH
> --
>
> On Sun, 18 Nov 2001 16:25:17
> Jared Still wrote:
> >
> >
> >---------- Forwarded Message ----------
> >Date: Sun, 18 Nov 2001 22:47:09 -0000
> >To: "'Jared Still'" <jkstill_at_cybcon.com>
> >
> >
> >Hi Jared,
> >I am sure you can help me on this.
> >I am encountering problems to run an O/S command from a stored
> >procedure/procedure.
> >The error log is as follows...
> >SQL>create library shell_lib as '/data1/dev/uexit/test/extproc.so';
> >SQL> create or replace function sysrun (syscomm in varchar2)
> > 2 return binary_integer
> > 3 as external
> > 4 name "sysrun"
> > 5 library shell_lib
> > 6 parameters(syscomm string);
> > 7 /
> >
> >Function created.
> >
> >SQL> declare rc number;
> > 2 begin rc := sysrun('/bin/ls -l');
> > 3 dbms_output.put_line('Return Code='||rc);
> > 4 end;
> > 5 /
> >declare rc number;
> >*
> >ERROR at line 1:
> >ORA-06521: PL/SQL: Error mapping function
> >ORA-06522: ld.so.1: extprocextproc: fatal: sysrun: can't find symbol
> >ORA-06512: at "UEXIT.SYSRUN", line 0
> >ORA-06512: at line 2
> >
> >Could you please help on this.
> >Thanks a lot.
> >Baral
> >

Innocent question : is LD_LIBRARY_PATH correctly set to include the directory where the .so is located ?

-- 
Regards,

Stephane Faroult
Oriole Corporation
Voice:  +44  (0) 7050-696-269 
Fax:    +44  (0) 7050-696-449 
Performance Tools & Free Scripts
--------------------------------------------------------------
http://www.oriole.com, designed by Oracle DBAs for Oracle DBAs
--------------------------------------------------------------
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Stephane Faroult
  INET: sfaroult_at_oriole.com

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).