FreeTDS Development Group

["Thompson, Bill D (London)" <bill_d_thompson AT ml.com>]

Bruce,

> Is this true?

No. Not as far as I know.

A stored procedure that returns more than one result set is no different
from a language command that does the same, e.g. 

"select * from publishers select * from authors"

However, one has to code the dblib API calls properly so that you detect
the end of one result set, capture the details of the new result set,
and act accordingly in terms of binding/fetching etc.

maybe PHP isn't doing that for stored procedures...

Bill


-----Original Message-----
From: freetds-bounces AT lists.ibiblio.org
[mailto:freetds-bounces AT lists.ibiblio.org] On Behalf Of Kall, Bruce A.
Sent: 13 April 2005 15:26
To: freetds AT lists.ibiblio.org
Subject: [freetds] sybase stored procedure error


Members,

Is this true?

> Apparently FreeTDS has issues with stored procs that return more than
one result set.


I appear to be having this problem as a stored procedure returning more 
than one result set results in the following error:

> dblib.c:303: buffer_add_row: Assertion `row_size <= buf->element_size'
failed.

Executing Sybase stored procedures that one return one result set run 
just fine.  I'm running it through php and freetds 0.62.  I've tried 
early versions of 0.63 to no avail.

Bruce
_______________________________________________
FreeTDS mailing list
FreeTDS AT lists.ibiblio.org
http://lists.ibiblio.org/mailman/listinfo/freetds
--------------------------------------------------------

If you are not an intended recipient of this e-mail, please notify the 
sender, delete it and do not read, act upon, print, disclose, copy, retain or 
redistribute it. Click here for important additional terms relating to this 
e-mail.     http://www.ml.com/email_terms/
--------------------------------------------------------