Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Running perl DBI in PLSQL on UNIX

Running perl DBI in PLSQL on UNIX

From: <katiesoh_at_gmail.com>
Date: 2 Apr 2005 05:07:39 -0800
Message-ID: <1112447259.251703.129350@o13g2000cwo.googlegroups.com>


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

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US