Ah! I see. I suspect your Java code isn't reading the stderr stream
where any (hepful) error message would be written. You could also
try adding something like
BEGIN { open STDERR, ">/tmp/my_stderr.log" }
or
BEGIN { open STDERR, ">&STDOUT" }
before the "use" statements.
Tim.
On Tue, Jul 02, 2002 at 01:55:16PM -0400, Hapworth, Adam wrote:
> I went through and looked for $dbh->err and $dbh->errstr and
> also did a trace. The err and errstr came up undef. Trace showed no obvious
> errors. My next step was to take out everything except fot the USE
> statements at the top and a print "foo\n" at the end.
>
> #!/usr/bin/perl -w
> use strict;
> use DBI;
> use DBD::Oracle qw(:ora_types);
> use Data::Dumper;
>
> print "foo\n";
>
> This when run throught the Java script ( I posted earlier ) it
> returned 2. That came from the Java WaitFor() routine which returns 0 for
> success or the system errno if it fails.
>
> Next I tried this.
> commented out the use DBD::Oracle qw(:ora_types);
>
> #!/usr/bin/perl -w
> use strict;
> use DBI;
> ###use DBD::Oracle qw(:ora_types);
> use Data::Dumper;
>
> print "foo\n";
>
> this when run throught the Java returned "foo".
>
> I am thinking that this problem that I am running into may be a SCO
> Unixware 7.1.1 (or others) issue with DBD::Oracle. I do not have access to
> another Oracle instalation on any other platform machine with perl on it to
> try to duplicate this issue. Since calling DBD::Oracle I get the system
> error of 2 and also when I do a connect which in turn calls DBD::Oracle I
> get the same error.
