Re: Problem w/VB 5, 7.23.UC6, stored procedures

Posted in 1999

mcollins@us.dhl.com — Wed, 4 Aug 1999 15:45:22 -0600 — source: Informix-list mailing list archive (1991-1998)

> This is a bug in OpenLink. It has problems with procedures that do not > return values in a transaction. I assume it fails to initialise something. > The solution is to have a dummy procedure that returns a dummy value, and > call it every time: > > BeginTran > Execute dummy procedure that returns a value > Read dummy value > Execute real procedure that does not return a value > CommitTran. Well isn't that weird. Interesting work-around. We have had feedback from OpenLink about this, and they said it was fixed in the new 3.2 release. I won't be able to test it until next week at the earliest, though. If it doesn't work we may have to use your alternative. Thanks for the information. Mark Collins mcollins@us.dhl.com