Re: Temporary tables, stored proedures and cyrstal reports

From: David T. Bath <david.bath_at_nre.vic.gov.au>
Date: Tue, 23 Jun 1998 11:13:11 +0000
Message-ID: <358F8DC7.F3E9197D@nre.vic.gov.au>

Dallas Taylor wrote:
>
> i have previously used MS SQL SERVER. with it i was able to create
> temporary tables in a stored procedure. i was also able to run the stored
> procedure from crystal reports and create reports around the data
> returned by the stored procedure.
>
> i now need to do similar things in oracle. are they possible? and if so how?
>
> thanks
> dallas

Check out the "DBMS_SQL" package and procedures/functions therein.

--

---

David T. Bath at home
david.bath_at_nre.vic.gov.au
Phone: +613 9500 0894 Mobile: 015 824 171 (not always on) Office: Global Consulting Ph:+613 9347 7511 Fax:+613 9347 0182

---

Received on Tue Jun 23 1998 - 06:13:11 CDT