Table as parameter to stored procedure?
Hello,
Is there any possibility to generate a stored procedure which takes a
table as one of its parameters?
e.g. I need something like this:
CREATE PROCEDURE next_indexvalue(mytable TABLE) RETURNING INTEGER; DEFINE result INTEGER
select max(mytable.indexcolumn)+1 INTO result from mytable
RETURN result
END PROCEDURE
DOCUMENT 'This Procedure returns the next free Index Value for a given
Table'
How can I implement this?
Thank you,
Erhard Schwenk