Re: Stored Procedures
On Mon, 14 Feb 2000, Daniel [iso-8859-1] Isv'n wrote:
> I get the most stupid errors when I try to create a stored procedures.
> But probabli I'm the one that's stupid. I have never done this before so
> I don't really know what to do and I can't seem to find anything about
> it in any manual either. Can anyone help me with this.
> I'm trying to create the procedure below and i get error -201, syntax
> error.
>
> CREATE PROCEDURE proc_name
> RETURNING INTEGER;> RETURN 7;
> END PROCEDURE
Change your first line to:
CREATE PROCEDURE proc_name()