高分求:怎么在存储过程里调用sqlldr??在线等.
解决方案 »
- 如何从oracle92转到oracle817
- ORACLE过程中如何将变量值打印出来?
- oracle 10g 为什么没有enterprise manager
- 请问Oracle9i能不能冷备份,如果能,怎么备份?
- 怎样将oracle中的某个表以txt的文件导出
- 如何给表、列加注释?
- 一个ORACLE菜鸟问题,但很急,望各位大虾相助
- 要北航软件学院的硕士双证,还是要北大的硕士单证!
- 数据导入错误IMP-00013的问题
- DataFactory 创建Oracle数据库报NO access library for'or84d.dll'
- 如何手动配置Oracle 10g的DBConsole服务?请各位大虾指点
- 救命 ORA-00942: 表或视图不存在
connect sys/change_on_install
grant create any library to scott;
connect scott/tiger
create or replace library clib as 'c:\winnt\system32\crtdll.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:\temp\loader\data.ctl log=d:\temp\loader\data.log errors=100';
retval := plsql_system( cmd );
dbms_output.put_line( retval );
END;/
grant create any library to scott;
connect scott/tiger
create or replace library clib as 'c:\winnt\system32\crtdll.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:\temp\loader\data.ctl log=d:\temp\loader\data.log errors=100 ';
retval := plsql_system( cmd );
dbms_output.put_line( retval );
END;/