Re: Can ADO to Oracle do this?

Lok,

yes - oracle 9i does support temporary tables -- check the oracle docs, because they work much differently from sqlserver. you can not directly execute ddl statememts from within an oracle stored procedure. to create a table, for instance, within a pl/sql block (either named or anonymous) you need to use the "execute immediate" form.

regards
roy fine

"LOK Kok Wah" <lokkokwah_at_yahoo.com> wrote in message news:b3da7c$6o0$1_at_reader01.singnet.com.sg...
> -newbie to oracle, looking to do something similar in oracle
>
> in mssql I can write a stored procedure to do the following
>
> create procedure
> create table #temptbl (a varchar(20))
>
> insert #temptbl ........ values (whole list)
> select * from #temptbl
>
> from ado, I can define a recordset oobject and run the SP and the results
> of the #temptbl will be in the recordset
>
> 1. can I have such temp tables in oracle? which version would support
this?
> 2. in oracle stored procedure, i do not seem to be able to a select
without
> putting the results into a table i.e. I cannot do select * from table -
> it expects the results to go into a table
>
> I'm trying to avoid creating a permanent table and if oracle can do the
same
> would be excellent
> cheers!
>
> mailto:lokkokwah_at_yahoo.com
>
>
>
Received on Mon Feb 24 2003 - 20:03:02 CET