| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> RE: Fwd: Extproc problem...
Hi,
The exact command to read the contents of .so file in Unix is "nm".
The Syntax is nm <shared object file name>
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:Received on Mon Nov 19 2001 - 23:58:02 CST
>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
>>
>>
>>***************************************************************************
>**
>>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_at_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_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).
>>
>
>
>--
>Please see the official ORACLE-L FAQ: http://www.orafaq.com
>--
>Author: C.S.Venkata Subramanian
> INET: csvenkata_at_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_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).
>--
>Please see the official ORACLE-L FAQ: http://www.orafaq.com
>--
>Author: Khedr, Waleed
> INET: Waleed.Khedr_at_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_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).
>
-- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: C.S.Venkata Subramanian INET: csvenkata_at_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_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).
 |
 |