Running perl DBI in PLSQL on UNIX

Hi,
I'm having trouble executing my perl DBI program in PLSQL. The perl program connects to an Oracle 9203 database, does some DML and DDL and then writes the output to STDOUT and a file.

I have the following java method that I call from my PLSQL.

public class execperl{

   public static execperl(String paramfile){

       Process p = Runtime.getRuntime().exec("/tmp/myperlpgm " + paramfile);

   }
}

I did some troubleshooting by placing print statements at various lines in my code and the program always stop before the OPEN statement. If I comment the OPEN, it exits when I do a subroutine call.

The java stored procedure works fine in PLSQL if I run simple command like /bin/ls or a simple perl script that does some printing to STDOUT.

Are there any restriction/limitation with what I'm trying to accomplish?

Thanks.

kat Received on Sat Apr 02 2005 - 07:07:39 CST