PEPPLER.ORG
Michael Peppler
Sybase Consulting
Menu
Home
Sybase on Linux
Install Guide for Sybase on Linux
General Sybase Resources
General Perl Resources
Freeware
Sybperl
Sybase::Simple
DBD::Sybase
BCP Tool
Bug Tracker
Mailing List Archive
Downloads Directory
FAQs
Sybase on Linux FAQ
Sybperl FAQ
Personal
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
-- 
Michael Peppler  -  mpeppler@peppler.org  -  http://www.peppler.org/
Sybase DBA/Developer
Sybase on Linux FAQ: http://www.peppler.org/FAQ/linux.html