Re: Stor. proc. & temp tables dynamical
From: Steve Gutterman <sgutterman_at_dreamworks.com>
Date: 1996/03/07
Message-ID: <4hnfqo$p9n_at_argentina.it.earthlink.net>#1/1
Date: 1996/03/07
Message-ID: <4hnfqo$p9n_at_argentina.it.earthlink.net>#1/1
In article <4hlagm$dcb$2_at_mhadg.production.compuserve.com>,
76756.3641_at_CompuServe.COM says...
>
>can you create temp tables dynamically in ORACLE 7.x Stored
>Procedures. Or do you have to have them created before entering
>the SP.
>
>robin cyrus
>First Interstate Bank
>Arizona
>
>--
> F. I. B. of Arizona
Check out the Oracle package DBMS_SQL that allows this. I'm not sure starting with which version it comes with Oracle. We use 7.1.3 (I think) and we have it. Received on Thu Mar 07 1996 - 00:00:00 CET