Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Re: about temporary tables in reports 6.0
ayman mahli wrote:
> i'm really having a problem in creating a temporary table in reports
> 6.0 by using the SRW.DO_SQL(....) .when i run the report,a message is
> shown:(table doesn't exist) although i have taken in mind all of the
> conditions mentioned in the help topics.
> well,don't ask me to find an alternative for the temp. tables cze i
> know there isn't.
> i hope that anyone had this problem before could help me cze i can't
> represent my project while it's including (permanent tables) that r
> used only for intermediate processing.
> thank u.............
One of the worst practices you can engage in is to be building temporary tables on the fly: Especially in Reports.Build Oracle's global temporary tables and stay away from as much DDL as you can.
Daniel Morgan Received on Fri Jul 05 2002 - 11:28:31 CDT