stored procedures not working
Hello there,
I am trying to make a simple stored procedure work and I keep getting
syntax errors. Here is the procedure
create procedure getuser ()
returning char (15);
return user;
end procedure
Are there reasons besides syntax to why this procedure will not work??
Sent via Deja.com http://www.deja.com/
Before you buy.
In article <8k5q4n$cn2$1@nnrp1.deja.com>, cr8nk@my-deja.com writes
>Hello there,
>
>I am trying to make a simple stored procedure work and I keep getting
>syntax errors. Here is the procedure
>
>create procedure getuser ()
> returning char (15);>
> return user;
>
>end procedure
>
>Are there reasons besides syntax to why this procedure will not work??
>
Run the create procedure in dbaccess not isql.
isql does not support creating procedures.
>
>Sent via Deja.com http://www.deja.com/
>Before you buy.
--
David Williams