On Fri, Apr 06, 2001 at 02:13:17PM -0400, Jamie Orzechowski wrote:
> I tried sthX->finish and I get the same hangs ...
>
> I am split the script into seperate scripts and I run each part manually ...
>
> Even with the following script I get a hang ... if I insert sth->finish;
> then the script will hang ... If I remove it then script will run but I get
> the error
>
> DBI::db=HASH(0x80efd18) trace level set to 9 in DBI 1.14-nothread
> Can't locate object method "disconnect" via package "DBI::st" at ./test line
> 34.
This error occured because you called disconnect on a statement handle
rather than on the database handle.
I note that the code snippet you posted below isn't close to 34 lines long;
what is the actual code you used to produce this error?
Ronald
> #---------------------------------
> #script
>
> $dbh = DBI->connect("dbi:Sybase:database=xxxxxxxxxx", "xxxxx", "xxxxxxxx");
>
> $sql = <<_ENDSQL;
> Exec Subscribe_InsertPlan 13200,136,6,11,"$today"
> _ENDSQL
>
> $sth = $dbh->prepare($sql);
> $sth->execute || warn $sth->errstr;
> $dbh->trace(9);
> $dbh->disconnect;
>
