sybperl-l Archive

From: "Avis, Ed" <avised at kbcfp dot com>
Subject: No error raised for bad SQL in prepare() or fetchall_arrayref()
Date: May 6 2004 4:24PM

I expected this program to raise an exception for the bad query, but
it runs happily.

    use warnings;
    use strict;
    use DBI;
    my $dbh
       = DBI->connect("dbi:Sybase:server=MY_SERVER;database=mydb",
                      'login', 'password',
                       { RaiseError => 1 });
    my $sth = $dbh->prepare('malformed junk');
    $sth->fetchall_arrayref();
    finish $sth;
    disconnect $dbh;

I am using DBI-1.40, DBD::Sybase-1.02.6, on Linux (RH 8) against
Sybase 11.9.2, but I think with the 12.5 client libraries.

-- 
Ed Avis