Hi,

At December 6, 2004, 16:48, Lucas Franzen wrote:

> zamb1zz1 schrieb:

>>
>> create procedure sel_active_order_by_customer_id
>> (
>> user_id varchar(50)
> ^^^^^^^
>> )
>> returns
>> (
>> order_id_ int,
>> user_id_ varchar(50),
> ^^^^^^^

> which still has user_id as IN- AND OUTPUT param!!!!
> This is not valid!

Lucas, it's valid in this case since in the output parameter there an
underscore at the end and there's none in the input, so they are
different.

--
Best regards,
Daniel Rail
Senior System Engineer
ACCRA Group Inc. (www.accra.ca)
ACCRA Med Software Inc. (www.filopto.com)