Re: Running perl DBI in PLSQL on UNIX

katiesoh_at_gmail.com wrote in
news:1112458346.555664.22820_at_z14g2000cwz.googlegroups.com:

> Thanks for your suggestion. All the environment variables you listed
> have been set.
>
> The way I would like this to work is within a PLSQL program, a java
> stored procedure is called which then makes a call to the Perl program
> which sits on the database server. The Perl program connects to the
> database and does its job. yes, not efficient at all. This program is
> not called often and at most it runs about 15mins. So, I'm not too much
> concern with the performance or efficiency but to just make it work in
> PLSQL.
>
> I don't understand why the program would terminate when it execute
> OPEN.
>

permissions?
*nix environmental differences?
Relative pathname which does not exist for the (new) user?

You've said it has been running as a cron job. Who is the owner? Keep in mind that from within the DB it will be running as 'oracle' or who ever owns the $ORACLE_HOME tree.

One of the things I do to better understand what is happening is to

pwd > /tmp/my.pwd
env > /tmp/my.env

Then from another window/terminal I examine the contents of /tmp/my.*

When thing do not appear to be as they should, they probably aren't! Received on Sat Apr 02 2005 - 11:09:23 CST