At 09:45 AM 10/07/2003 +0800, you wrote:

>Fabrice Aeschbacher <fabrice.aeschbacher@...> wrote:Ghanshyam,
>
>Here is an example:
>
>create procedure MyProc ( InParam1 integer )
>returns ( OutParam1 integer, OutParam2 as varchar(10))
>......
>
>
>hello:
>
> I think no the 'as' in returns.Is it all right?

You're right, it looks like a typo. You don't use 'AS' when declaring
output variables stored procs...

heLen