Re: [Q]: CONTEXT one-step query in PL/SQL procedure

On Thu, 19 Feb 1998 15:41:32 -0000, Fat Boy Slim <fatty_at_boy.slim.com> wrote:
>Thanks Keith.
>
>The problem I now have is that in order to use ctx.contains I need a
>intermediate results table. Now, I will be having several concurrent users
>on this system and they will al be attached as the same user name (as this
>is being executed from Oracle Web Agent).
>
>So, for my next question, how can I create an intermediate results table
>that is individual to the specific session, which to complicate things
>further will be setup and destroyed each time I serve up a web page
>containing 10 rows from the result set? (ie the end user wants to page
>through the result set, 10 at a time, and OWA starts a fresh session each
>time a call is made to it).

We had the same problem. The first thing we did was dump OWA, but that's not the only answer. The trick is to maintain the query_id. I believe this is possible by using hidden values. Once you figure that out (It's not too tough, we just had lots of other problems with OWA), you can use ROWNUM to get the information you want (i.e. "SELECT id WHERE ROWNUM > 10"). Oracle does not automatically clean up results from a two-step query. However you will need to have some sort of daemon running which deletes results after they have aged a certain amount of time (dependant on you application).

>
>Quentin North
>
>Keith E. Moore wrote in message ...
>>On Thu, 19 Feb 1998 11:41:04 -0000, Fat Boy Slim <fatty_at_boy.slim.com>
 wrote:
>>>Hi

[snip my stuff]

-- 
-- Keith Moore
   President
   KMA Computer Solutions, Inc.

-- 
/*----C/C++--Java--VB--Pro*C--SQL--OCI--Java--Delphi--ODBC--COBOL-----* 
 *        When the project must be saved at all costs:                *
 * KMA Computer Solutions, Inc.   Project Troubleshooting/Recovery    *
 *---------Linux---AIX---HPUX---SYSV---Novell---NT---OS/2---'95-------*/