| Subject | CREATE TABLE in stored procedure |
|---|---|
| Author | Alejandro Garcia |
| Post date | 2007-04-03T12:34:09Z |
Hi!! Is it possible to CREATE TABLE in a stored procedure in InterBase 7.5?
It seems that it isn't, it allows SELECT, INSERT, DELETE, UPDATE but not CREATE:
"SQL data manipulation statements: INSERT, UPDATE, DELETE, and singleton SELECT. Cursors are allowed."
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 ?
---------------------------------
LLama Gratis a cualquier PC del Mundo.
Llamadas a fijos y móviles desde 1 céntimo por minuto.
http://es.voice.yahoo.com
[Non-text portions of this message have been removed]
It seems that it isn't, it allows SELECT, INSERT, DELETE, UPDATE but not CREATE:
"SQL data manipulation statements: INSERT, UPDATE, DELETE, and singleton SELECT. Cursors are allowed."
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 ?
---------------------------------
LLama Gratis a cualquier PC del Mundo.
Llamadas a fijos y móviles desde 1 céntimo por minuto.
http://es.voice.yahoo.com
[Non-text portions of this message have been removed]