Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: ConText GETTAB procedure

Re: ConText GETTAB procedure

From: Richard Murphy <rmurphy_at_lbpc.com>
Date: Wed, 27 Jan 1999 23:01:31 GMT
Message-ID: <36AF9AF0.DB368CC3@lbpc.com>


Evidently once a session uses the GETTAB() procedure, that table is locked solely to that session until the RELTAB() procedure is called.

Richard Murphy wrote:

> According to the documentation the CTX_QUERY.GETTAB() procedure creates
> a hitlist result table or returns the name of an existing one that has
> the same number of textkeys. When i execute the procedure i get a new
> table each time i call it even though there already exists similar
> result tables. I am running a server program for each remote user
> loging in ( hundreds) with multiple two-step queries in the server code,
> potentially resulting in thousands of result tables being created.
>
> Anyone know why the tables are not being reused?
>
> Thanks, Richard M.
Received on Wed Jan 27 1999 - 17:01:31 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US