Home » Developer & Programmer » JDeveloper, Java & XML » java stored procedure
java stored procedure [message #366770] Tue, 12 December 2000 02:30
Sudha
Messages: 29
Registered: November 2000
Junior Member
i had created a java class which runs the system command. the code is given below.
create or replace java source named "mdir" as
public class mdir{
public static void mdr(){
try {
Process p = Runtime.getRuntime().exec("ftp ......... );
}
catch (Exception e) {}
}
}

when i run it from the server (ie. using telnet and connecting to the linux, it is functioning well).
but when i tried to create a procedure in pl/sql
it show successfully executed, but when i go and see the server the file which has to be transfered is not there. the pl/sql code is
create or replace java source named "mdir" as
public class mdir{
public static void mdr(){
try {
Process p = Runtime.getRuntime().exec("ftpput ...... );
}
catch (Exception e) {}
}
};

create or replace procedure mdr2 as
language java name 'mdir.mdr()';
/

SQL> exec mdr2();

PL/SQL procedure successfully completed.
pl. help
Previous Topic: Oracle JDBC Thin - Connection refused
Next Topic: Java and Oracle listener
Goto Forum:
  


Current Time: Thu Mar 28 12:54:04 CDT 2024