| 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
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
