java存储过程调用_java存储过程调用OS命令

1. 先看一下这个目录

[oracle@ocean ~]$ pwd

/home/oracle

[oracle@ocean ~]$ ls -l

total 8

-rw-r--r-- 1 oracle orains 604 Dec 26 2006 bash

2. 连接到test用户

SQL> conn test/test

Connected.

3. 授于test用户文件读写和执行命令的权限

SQL>exec dbms_java.grant_permission('TEST','SYS:java.io.FilePermission','<>','read,write,execute,delete');

PL/SQL procedure successfully completed.

SQL>exec dbms_java.grant_permission('TEST','java.lang.RuntimePermission','*','writeFileDescriptor' );

PL/SQL procedure successfully completed.

4. 建立java存储过程,注意,这里的exp 路径和dmp文件的路径是数据库服务器的路径

create or replace and compile java source named "aa"

as

import java.io.*;

import java.lang.*;

import java.util.*;

import java.sql.*;

import oracle.sql.*;

public class aa

{

public static void invoke_exe() throws IOException

{

Process p=Runtime.getRuntime().exec("/oracle/product/9.2.4/bin/exp userid=test/test file=/home/oracle/test.dmp");

try

{

p.waitFor();

}catch(InterruptedException ie){System.out.println(ie);}

}

}

/

Java created.

Elapsed: 00:00:00.01

5. 建立调用java存储过程的存储过程call_aa

create or replace procedure call_aa

as language java

name 'aa.invoke_exe()';

/

6. 执行java存储过程

exec call_aa;

7. 检查一下dmp文件是否已经生成

[oracle@ocean ~]$ pwd

/home/oracle

[oracle@ocean ~]$ ls -l

total 28

-rw-r--r-- 1 oracle orains 604 Dec 26 2006 bash

-rw-r--r-- 1 oracle orains 16384 Jul 3 14:12 test.dmp

-----------------

exec dbms_Java.Grant_Permission('TEST', 'java.io.FilePermission', '<>', 'read ,write, execute, delete');

exec dbms_Java.Grant_Permission('TEST', 'java.io.FilePermission', 'd:aa.bat', 'read ,write, execute, delete');

exec dbms_java.grant_permission('TEST','java.lang.RuntimePermission','*','writeFileDescriptor' );[@more@]