Subject Re: [firebird-support] Firebird Temporary Table
Author Aris Mardi
Hi Arno,

Thank you for your response.
Concerning temporary table. Is it possible to put both ddl temporary table creation and temporary table selection on a single stored procedure ? Regarding the ddl creation need to be committed first and it doesnt allow commit command on stored procedure (correct me if im wrong).


On Saturday, October 31, 2015 5:40 AM, "'Arno Brinkman' fbsupport@... [firebird-support]" <> wrote:


> I am using firebird 2.5.

> Need to use temporary table on my stored procedures. I am able to create
> temporary table using create global temporary table command.
> But when i select it, it returns 'unknown table' error. Did i do it wrong
> ?
> I would like to know how to use global temporary table in firebird.

Those are Connection or Transaction bound, may be there is your problem,
read for more info:

Kind Regards,
Arno Brinkman