Re: Question about MS SQL to Oracle conversion - Temp Tables in Procs

Interesting problem. The short answer is yes, Oracle does have a programming construct available in PL/SQL for creating temporary tables. These are actually memory structures that are only available within the scope of the executing program, rather than actual database objects (the usage of the term "table" is confusing).

However, I question wether this is the best thing to do given the context of your problem: a web app. What mechanism are you using to make your web app data-aware? Are you using the Oracle Application Server and PL/SQL toolkit, or some other means of accessing the database?

Typically, web applications are stateless: they don't maintain a persistant connection to the database, so using a temporary table won't solve the issue at hand.

As an alternative, you could use either a cookie mechanism or hidden form fields to keep track of record paging.

In article <WhG96.380$Ix.153800_at_dfiatx1-snr1.gtei.net>,   "Preston Crawford" <prestoncREMOVESPAMBLOCK_at_crawfordsolutions.com> wrote:
> I'm working at a company currently that uses a primarily Oracle
 environment.
> So I'm becoming familiar with Oracle right now. As I do, I'm still
 doing
> some work on a temporary database using MS SQL Sever 7.0 and writing
 a few,
> very generic queries that I'll hopefully be able to port over without
> trouble. I ran into one today, though, where the best way I can see
 to do it
> is with a temporary table. I wanted to know if there is a way to
 create
> temporary tables within stored procedures in Oracle. Specifically, I
 believe
> we are using Oracle 7.1.3 (or something to that effect.) So before I
 embark
> on doing this, I wanted to know if anyone had any ideas, opinions on
 this.
> Even including how to avoid using these.
>
> My reason for using them is I'm writing a web app where records are
 paged
> through. It's handy to use a temp table to page because the temp
 table can
> have a counter field that you can reliably use to select records
 between a
> range for the sake of paging. Any ideas?
>
> Preston
>
>

Sent via Deja.com
http://www.deja.com/ Received on Thu Jan 18 2001 - 13:57:45 CST