Oracle OCI - No ora

You are viewing an archived Text-only version of the thread. To view this thread in it's original format and/or if you want to reply to this thread please [click here]

Author

No ora_errno

Douglas Harter

2005-06-04, 3:24 am

I am doing a
use Oraperl;
on a Sun Unix system in perl.

My problem is I cannot seem to get anything from ora_errno or orr_errstr.

I have put in what I know is a bad select statement into my string to
ora_open. I am putting in a value for a where which I know is not there.
This string gives me a record not found using sqlplus. If I put in a good
value I get a valid find.

However, I get an undef to both ora_errno and ora_errstr from the ora_open
and ora_fetch.

My version of Oraperl is 3.000.

The statements I am using are:
my $csr = & ora_open($lda,$sql);

my ($id,$email,$last,$f
irst) = &ora_fetch($csr);

..

Sponsored Links