On Fri, 25 Jul 2003 11:38:24 -0400 "Harter, Douglas" <[EMAIL PROTECTED]> wrote:
> 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,$first) = &ora_fetch($csr); The proper list for this is [EMAIL PROTECTED] I would have read it about two days earlier there. $ora_errno and $ora_errstr are status variables, not subroutines. An example of how you are using them would help someone help you. The fine manual is available as `perldoc Oraperl` or at http://search.cpan.org/dist/DBD-Oracle/Oraperl.pm . -- Mac :}) ** I usually forward private questions to the appropriate mail list. ** Ask Smarter: http://www.catb.org/~esr/faqs/smart-questions.html Give a hobbit a fish and he eats fish for a day. Give a hobbit a ring and he eats fish for an age.
