[prev in list] [next in list] [prev in thread] [next in thread] 

List:       solid
Subject:    RE: Sequence Stored Procedur
From:       "Revital Donenfe" <donenfe () checkpoint ! com>
Date:       1999-08-29 6:51:10
[Download RAW message or body]


Hi,
Try this line (without the brackets):

EXEC SEQUENCE my_sequence.NEXT INTO val;

Revital.

-----Original Message-----
From:	solid-list@solidtech.com [mailto:solid-list@solidtech.com] On Behalf
Of Ivor Flannery
Sent:	Sunday, August 29, 1999 4:06 AM
To:	'solid-list@solidtech.com'
Subject:	Sequence Stored Procedur

I'm afraid I must be reading the admin guide wrong.  When I try to
submit this statement (verbatim from the Admin Guide) to Solid
03.00.0051 I am getting a syntax error.  I have checked the docs again
and don't see the error.  Am I just really stupid or can anybody tell me
what I am missing here ??


"CREATE PROCEDURE get_my_seq
RETURNS (val INTEGER)
BEGIN
EXEC SEQUENCE my_sequence.NEXT INTO (val);
END";

SOLID Procedure Error 23004: Syntax error: parse error, line 4

[prev in list] [next in list] [prev in thread] [next in thread]