Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Mailing Lists -> Oracle-L -> Fwd: Extproc problem...
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
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
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). Received on Sun Nov 18 2001 - 18:56:51 CST