Re: Stored Procedure Error

> I am getting an syntax error while trying to create the following > stored procedure. I want to pass in an item_code and return the > weight of that item. I have tried changing the decimal(9,2) to an > integer with no luck. I would appreciate any help. Did you use isql when you tried to create this procedure? I have been bitten by a wierd quirk of Informix stored procedures that may be the culprit here. You can use isql to create stored procedures as long as they don't return anything. If they have return values, you HAVE to use dbaccess to create them. Of course, you can use dbaccess regardless of whether the SP returns anything. Mark Collins mcollins@us.dhl.com The problem lies in how easily and dangerously we forget that manipulating things is not the same as understanding them.