DDL Commands in Reports [message #150347] |
Wed, 07 December 2005 08:16 |
kitab
Messages: 3 Registered: June 2005
|
Junior Member |
|
|
Hi All,
Can we create table using oracle report? If yes, please provide details.
Thanks in advance.
Kitab
|
|
|
Re: DDL Commands in Reports [message #150357 is a reply to message #150347] |
Wed, 07 December 2005 09:10 |
|
Maaher
Messages: 7065 Registered: December 2001
|
Senior Member |
|
|
I strongly advise against it! Reports is a reporting tool, keep it that way. Don't create tables on the fly.
But, sigh, I guess you could use a report trigger and use FORMS_DDL or a server side procedure.
But again: just don't.
If you need temporary tables, use GLOBAL TEMPORARY tables or PL/SQL tables or User Defined types...
MHE
|
|
|