Re: raise exception returned error length

FProse wrote: > After a little digging we discovered that the maximum length of the > error text returned by a "raise exception" is 71 characters. > > While I'm not looking to write the last great novel I've got a problem > in that PowerDesigner generates stored procedures with a error text > that assumes 255 characters. > > My question is this: has anyone figured a way around this limitation? Well, I suppose you could redefine the SQLCA structure so that the sqlerrm string was longer than 72 characters (including trailing ASCII NUL '\\0')... Other than that, using a table of some sort seems about right, as Christian Brauer suggested. You might return the ID string in the 'short' message, and encode the date, time, and ID string and long message in the secondary table. Given that you're using PowerDesigner, I suspect the short answer to your problem is actually "No" because you're unlikely to be able to get it to change its mind about the length of error message. -- Jonathan Leffler (jleffler@informix.com, jleffler@earthlink.net) Guardian of DBD::Informix v0.62 -- see http://www.perl.com/CPAN #include <disclaimer.h>