Can ADO to Oracle do this?

From: LOK Kok Wah <lokkokwah_at_yahoo.com>
Date: Mon, 24 Feb 2003 22:34:43 +0800
Message-ID: <b3da7c$6o0$1_at_reader01.singnet.com.sg>

[Quoted] [Quoted] -newbie to oracle, looking to do something similar in oracle

[Quoted] 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 [Quoted] [Quoted] putting the results into a table i.e. I cannot do select * from table - it expects the results to go into a table

[Quoted] 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 - 15:34:43 CET