HI,
I am running perl 5.00503 on a SCO UnixWare 7.1.1 box with Oracle
8.16 installed. I am using DBI version 1.21 and DBD::Oracle Version 1.12 to
connect to the database. What I am trying to do is to write a piece of Java
which will run the Perl script I am writing on the server. The Perl script
works without crashing when run from the prompt. When I run it through the
Java script I have borrowed (got it from
http://asktom.oracle.com/pls/ask/f?p=4950:8:989284::NO::F4950_P8_DISPLAYID,F
4950_P8_CRITERIA:952229840241,%7BJAVA%7D%20and%20%7BUnix%7D ) it crashes and
displays a system error number of 2.
After banging my head I decided to place a number of $! and $? to
see where I was if at all getting an error 2 from my perl script. I found
that it occurs after my DBI->connect(). My connect string looks like so:
$dbh = DBI->connect("dbi:Oracle:host=$host;sid=$sid",$user,$pass) || die
"connection to Database Failed$!";
The error message that a print $! displays is "Operation not applicable" I
have looked this up in a number of different places and I have found only
found a description of the error which states:
"This error indicates that no system support exists for some function that
the application requested ...
The symbolic name for this error is ENOSYS, errno=89."
I am not using any ENV variables in case that helps.
I am wondering where and why this may be getting set and how to get around
it properly.
Thank you
Adam Hapworth
