Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: ConText GETTAB procedure
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