Michael Peppler
Sybase Consulting
Sybase on Linux
Install Guide for Sybase on Linux
General Sybase Resources
General Perl Resources
BCP Tool
Bug Tracker
Mailing List Archive
Downloads Directory
Sybase on Linux FAQ
Sybperl FAQ
Michael Peppler's resume

sybperl-l Archive

Up    Prev    Next    

From: Michael Peppler <mpeppler at peppler dot org>
Subject: Re: Bizarre ASE bug triggered by latest test DBD::Sybase
Date: Apr 26 2005 6:24PM

On Mon, 2005-04-25 at 18:32, Avis, Ed wrote:
> I believe the current (1.05.xx) test release of DBD::Sybase has changed
> to use 'chained mode' if AutoCommit is off.  This has tickled a Sybase
> bug which didn't appear with earlier DBD::Sybase versions.  Here's the
> test program:

> This gives the error
> DBD::Sybase::db do failed: Server message number=7713 severity=16 state=2 line=1 server=IT_LN text=Stored procedure '*ss1492368299_0739474268ss*' may be run only in unchained transaction mode. The 'SET CHAINED OFF' command will cause the current session to use unchained transaction mode.
> Bizarre - I didn't call any stored procedure.  What is odder still is
> that any change to the SQL text, even adding a newline on the end, stops
> the error happening.  So I suspect some horrible memory trampling inside
> Sybase.

Do you have statement caching turned on for that server?

I haven't had time to try to reproduce it yet...

Michael Peppler  -  -
Sybase DBA/Developer
Sybase on Linux FAQ: