Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Re: about temporary tables in reports 6.0

Re: about temporary tables in reports 6.0

From: Daniel Morgan <dmorgan_at_exesolutions.com>
Date: Fri, 05 Jul 2002 16:28:31 GMT
Message-ID: <3D25C907.EE42B123@exesolutions.com>


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

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US