zamb1zz1 schrieb:

>
> Alright, but here's an example, I just tried to create the sproc I
> posted earlier - without quotes. I get an error, here's the error &
> sproc:
>
> ISC ERROR CODE:335544569
>
> ISC ERROR MESSAGE:
> Dynamic SQL Error
> SQL error code = -104
> Token unknown - line 22, char 18
> _order_id
>
> 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!

Luc.