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

Thanks. I actually found a better way to do this server-side and avoid the temp tables. I just assumed they were available. I'm going to have to work hard to lose some of my crutches as I adjust to life with Oracle.

Preston

"Ezr Vinh" <d_a_p_at_my-deja.com> wrote in message news:947hrj$o7u$1_at_nnrp1.deja.com...
> 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 Fri Jan 19 2001 - 11:29:58 CST