Subject | RE: [firebird-support] Re: Declare and use array datatype in stored procedures |
---|---|
Author | Hans |
Post date | 2012-12-30T21:59:01Z |
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.
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.