Re: Stored Procedure Error
Bill Sampler schrieb:
> Hello everyone,
>
> 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.
>
> create procedure item_weight(l_item char(20))
> returning decimal(9,2);> # ^
> # 201: A syntax error has occurred.
> #
> define l_weight decimal(9,2);
<SNIP>
Bill,
I copied your procedure right out of your post into a dbaccess window,
removed the error message and ran it.
It worked! No Syntax Error.
Do you try to run this via isql?
Regards,
Roland