Subject Re: [firebird-support] CREATE TABLE in stored procedure
Author Martijn Tonies
Hi,

>Hi!! Is it possible to CREATE TABLE in a stored procedure in InterBase 7.5?

No.

> It seems that it isn't, it allows SELECT, INSERT, DELETE, UPDATE but not
CREATE:

Correct.

> And I'm getting an error message when I try to compile it..
> Do I have to create the table before to use it as a temporal table in a
procedure ?

Indeed.

Martijn Tonies
Database Workbench - the IBConsole alternative!
Upscene Productions
http://www.upscene.com
My thoughts:
http://blog.upscene.com/martijn/
Database development questions? Check the forum!
http://www.databasedevelopmentforum.com