exec dbms_java.grant_permission('abbas','java.io.FilePermission',
'D:\Abbas\Kuliah\Tes\loaddata1.bat','execute');
exec dbms_java.grant_permission( 'abbas', 'SYS:java.io.FilePermission',
'D:\Abbas\Kuliah\Tes\loaddata2.bat', 'execute' );
exec dbms_java.grant_permission('abbas', 'java.lang.RuntimePermission', '*',
'writeFileDescriptor' );
/
connect abbas/abbas
/
create or replace and compile
java source named "Util"
as
import java.io.*;
import java.lang.*;
public class Util extends Object
{
public static int RunThis(String args, String[] cmdOutput)
{
Runtime rt = Runtime.getRuntime();
int rc = -1;
String coutput = " ";
String ot = " ";
try
{
Process p = rt.exec(args);
/*
int bufSize = 4096;
BufferedInputStream bis =
new BufferedInputStream(p.getInputStream(), bufSize);
int len;
byte buffer[] = new byte[bufSize];
// Echo back what the program spit out
while ((len = bis.read(buffer, 0, bufSize)) != -1) {
System.out.write(buffer, 0, len);
ot = new String(buffer, 0, len);
coutput = coutput + ot;
}*/
rc = p.waitFor();
}
catch (Exception e)
{
e.printStackTrace();
rc = -1;
}
finally
{
cmdOutput[0] = coutput;
return rc;
}
}
}
/
create or replace function RUN_CMD( p_cmd in varchar2, p_cmd_out out
varchar2)
return number as
language java
name 'Util.RunThis(java.lang.String, java.lang.String[]) return integer';
/
create or replace procedure RC(p_cmd in varchar2, p_cmd_out out varchar2) as
x number;
begin
x := run_cmd(p_cmd, p_cmd_out);
end;
/
set serveroutput on size 1000000
execute dbms_java.set_output(1000000)
declare
r varchar2(4000);
begin
rc('D:\Abbas\Kuliah\Tes\loaddata1.bat D:\Abbas\BD.txt', r);
end;
Diperbaiki aja codenya ya.
[Non-text portions of this message have been removed]
