Subject RE: [firebird-support] Re: Declare and use array datatype in stored procedures
Author Hans
Maybe a Temporary table will do it. Something like:

CREATE GLOBAL TEMPORARY TABLE SESSION_VARS
(
USER_UNIQUENUM integer NOT NULL,
TICKET_UNIQUENUM integer NOT NULL
)
ON COMMIT PRESERVE ROWS; (More options available here)

It is unique for each connection and lasts as long as the connection lasts.
Information can be used/updated/inserted by all procedures and triggers,
alike a memory table but residing on the server.