Re: Stored Procedures
From: Daniel Isv'n <daniel.isven@tubenteknik.se>
>
>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.
http://www.informix.com/answers/ -- get the SQL syntax guide.
>CREATE PROCEDURE proc_name
> RETURNING INTEGER;> RETURN 7;
>END PROCEDURE
I think it should be
CREATE PROCEDURE proc_name()
-- ...............missing ^^
RETURNING INTEGER; RETURN 7;
END PROCEDURE
______________________________________________________
Get Your Private, Free Email at http://www.hotmail.com