Re: Problem in executing stored procedure.

Ravi Hubbly wrote: > > <SNIP> > The stored procedure, upon execution, gives an error "Resulting string length > must be less than or equal to 255". I've got a char variable of length 3000 > which I am returning from the SP. > > CREATE PROCEDURE "sstm".g_wo_sm006a( > p_wo_no LIKE work_order.wo_no > ) > RETURNING > VARCHAR(9,0), > VARCHAR(8,0), > . > . > CHAR(3000), -----> This is the return variable which causes the problem > CHAR(1); I hate to point out the obvious.... But... If you are returning tye CHAR, then why don't you define your RETURNING clause as returning type CHAR instead of VARCHAR? VARCHAR is restricted to 255 chars, whereas CHAR allows 32767. So I can only imagine that 7.10.UC2 has a bug that ignores this. Hope this helps, -- Mark. +-------------------------------------------------------------------------+ |Mark D. Stock - The West Solutions Group http://www.west.co.za | | The Informix FAQ is at http://www.iiug.org | |mailto:marks@west.co.za +------------------------------------------------+ |Tel: +27 11 803 2151 |If it doesn't work... force it! | |Fax: +27 11 803 2189 |If it breaks... it needed replacing anyway! | |Cell: +27 83 250 2325 |Well, that's how I code anyway! | +------------------------+------------------------------------------------+