Subject Re: [firebird-support] Firebird Temporary Table
Post date 2015-10-31T00:43:40Z
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).

Regards,
Aris.



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


 
Hello,

> 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:
http://www.firebirdsql.org/refdocs/langrefupd21-ddl-table.html

Kind Regards,
Arno Brinkman
ABVisie
arno@...