| Subject | Re: [firebird-support] Firebird Temporary Table |
|---|---|
| Author | Aris Mardi |
| 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,
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@...
> 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@...