Procedure java will not create a file until i disconnect

[steeve123]

SORRY, THIS WAS NOT POSTED IN THE RIGHT FORUM

I have a procedure java that execute an export command on the oracle server. It works, but only when i disconnect from my sqlplus session. Why does the export will not work right away?

Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - Prod
PL/SQL Release 10.2.0.1.0 - Production
CORE 10.2.0.1.0 Production
TNS for 32-bit Windows: Version 10.2.0.1.0 - Production
NLSRTL Version 10.2.0.1.0 - Production



Here is the code if you want to test it.

create user exp identified by exp;
grant connect to exp;
grant create procedure to exp;
grant create table to exp;
grant unlimited tablespace to exp;
connect exp/[email protected]

create or replace and compile java source named javacmdprompt as
import java.lang.*;
import java.util.*;
import java.util.Arrays;
import java.io.*;

public class javacmdprompt{
public static void cmdprompt(String directory) {
try {
Runtime.getRuntime().exec(directory,null);
}catch(IOException e){
System.out.println(e);
}
}

}
/

CREATE OR REPLACE Package My_pack as

Procedure proc_exec_cmd_java(p_commande in varchar2) as language java name 'javacmdprompt.cmdprompt( java.lang.String )';

End My_pack;
/

CREATE OR REPLACE Package body My_Pack as

Procedure proc_exec_cmd_java is

begin
null;
end proc_exec_cmd_java;

End My_Pack;
/

connect sys/[email protected] as sysdba

exec dbms_java.grant_permission( 'EXP','SYS:java.io.FilePermission', 'd:\oracle\product\10.2.0\db_1\BIN\exp', 'execute' )
exec dbms_java.grant_permission('EXP','java.io.FilePermission', '*', 'read, write');
exec dbms_java.grant_permission( 'EXP', 'SYS:java.lang.RuntimePermission','readFileDescriptor', '' );
exec dbms_java.grant_permission( 'EXP', 'SYS:java.lang.RuntimePermission','writeFileDescriptor', '' );

connect exp/[email protected]

create table My_table(no number);

execute My_pack.proc_exec_cmd_java('d:\oracle\product\10.2.0\db_1\BIN\exp userid=exp/exp file=d:\exp.dmp log=d:\exp.log consistent=y tables=(MY_TABLE)');

--
--IF I DISCONNECT I WILL SEE THE FILE D:\EXP.DMP
--
connect exp/[email protected]