From csvenkata@lycos.com Mon, 19 Nov 2001 21:58:02 -0800 From: "C.S.Venkata Subramanian" Date: Mon, 19 Nov 2001 21:58:02 -0800 Subject: RE: Fwd: Extproc problem... Message-ID: MIME-Version: 1.0 Content-Type: text/plain Hi, The exact command to read the contents of .so file in Unix is "nm". The Syntax is nm In your case it will be nm /data1/dev/uexit/test/extproc.so > extproc.txt This command will read the .so file and dump the contents in a text file. If you open the text file in a standard unix editor and search for the function u are calling in the pl/sql block. HTH For more clarifications pl email me. Venkat -- On Mon, 19 Nov 2001 08:55:18 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'" >> >> >>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 >> >> >>*************************************************************************** >** >>This message is confidential and for use by the addressee only. If you >>are not the intended recipient, you must not use, disclose, distribute, >>copy, print, or rely on this message. Please notify the sender by >>return email and then delete the message from your computer. Royal Skandia >>accepts no responsibility for changes made to this message after it was >>sent nor for any loss or damage from receipt or use. >> >>Royal Skandia Life Assurance Limited - a member of the Skandia Group of >>Companies - Reg No: 24916 Isle of Man - Registered Office: Skandia >>House, Finch Road, Douglas, Isle of Man IM99 1NU, British Isles - Regulated >>by the Personal Investment Authority for UK Investment Business - >>Member of the Association of International Life Offices. >> >>Internet: http://www.royalskandia.com >> >>*************************************************************************** >** >> >>------------------------------------------------------- >>-- >>Please see the official ORACLE-L FAQ: http://www.orafaq.com >>-- >>Author: Jared Still >> INET: jkstill@cybcon.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@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). >> > > >-- >Please see the official ORACLE-L FAQ: http://www.orafaq.com >-- >Author: C.S.Venkata Subramanian > INET: csvenkata@lycos.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@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). >-- >Please see the official ORACLE-L FAQ: http://www.orafaq.com >-- >Author: Khedr, Waleed > INET: Waleed.Khedr@FMR.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@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). > -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: C.S.Venkata Subramanian INET: csvenkata@lycos.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@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).