Re: String concatenation limits...?

Paul Did the SP work when you prepare it and pass the parameters in as "?" ? Dont think it will work otherwise, AFAIK. HTH Sujit Paul Harman <paul@kasterborus.demon.co.uk> on 02/18/2000 02:32:22 AM Please respond to Paul Harman <paul@kasterborus.demon.co.uk> To: informix-list@iiug.org cc: Subject: Re: String concatenation limits...? I asked the following question yesterday. Is the answer beneath everyone's contempt to answer, or do we genuinely not know? };*) Paul Paul Harman <paul@kasterborus.demon.co.uk> wrote in message news:hmVq4.325$7R.4650@news.colt.net... > CREATE PROCEDURE audittrailstr(event INTEGER, comment VARCHAR(255), value > CHAR(4096)) > DEFINE details CHAR(8192);> LET details=comment || ": " || value; > CALL audittrail(event, details); > END PROCEDURE; > > Now whenever I try to call this procedure, no matter how small the actual > values are for "comment" and "value", I get: > > 881: Resulting string length must be less than or equal to 255.> > Is string concatenation limited to 255 characters, or something? I didn't > have any problems before when my strings were all varchar(255)s but now I've > gone up to the 4K an 8K strings it's just not having any of it.

<Sujit.Pal@bankofamerica.com> wrote in message news:88k0jg$2mb$1@news.xmission.com... > Did the SP work when you prepare it and pass the parameters in as "?" ? Dont > think it will work otherwise, AFAIK. Unfortunately, I'm calling it from a trigger so that option isn't available to me. Paul