Execute SQL*Loader from Stored Proc [message #41014] |
Mon, 18 November 2002 02:24 |
jlz
Messages: 1 Registered: November 2002
|
Junior Member |
|
|
Hi,
I try execute SQL*Loader from a stored proc :
->
connect sys/change_on_install
grant create any library to scott;
connect scott/tiger
create or replace library clib as 'c:winntsystem32crtdll.dll';/
CREATE OR REPLACE FUNCTION plsql_system(cmd in varchar2)
RETURN BINARY_INTEGER AS EXTERNAL LIBRARY clibNAME "system";/
show errors
set serveroutput on
DECLARE cmd VARCHAR2(2000);
retval NUMBER;
BEGIN
cmd := 'sqlldr80.exe userid=test/test@hmg control=d:temploaderdata.ctl log=d:temploaderdata.log errors=100';
retval := plsql_system( cmd );
dbms_output.put_line( retval );
END;/
-------------------------------------------------
but this error occur :
ERROR at line 1:
ORA-28575: unable to open RPC connection to external procedure agent
ORA-06512: at "SCOTT.PLSQL_SYSTEM", line 0
ORA-06512: at line 6
Why ?
What can I do to run SQL Loader by StoredProc ??
Thanks
jl
|
|
|
Re: Execute SQL*Loader from Stored Proc [message #41015 is a reply to message #41014] |
Mon, 18 November 2002 04:10 |
Depa
Messages: 30 Registered: June 2002
|
Member |
|
|
do you have the following entry in the tnsnames.ora file
EXTPROC_CONNECTION_DATA =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC0))
)
(CONNECT_DATA =
(SID = PLSExtProc)
(PRESENTATION = RO)
)
)
|
|
|
|