Oracle8i interMedia Text Migration
Release 2 (8.1.6)

A77061-01

Library

Product

Contents

Index

Prev Up Next

PL/SQL Changes, 7 of 9


CTX_QUERY Package

2.x Package  Procedure  Status  Migration Notes 

CTX_QUERY 

CLOSE_CON 

Obsolete 

In-memory query obsolete.

Use FIRST_ROWS hint in SELECT statement to migrate in-memory queries.

See "Cursor Query" in Chapter 6. 

 

CONTAINS 

Obsolete 

Two-step queries no longer supported - Use SELECT statement with CONTAINS function to perform queries

See "Text Query" in Chapter 6. 

 

COUNT_HITS 

Changed 

Specify index rather than policy. The struct_query parameter is also obsolete.

See "Counting Hits" in Chapter 6. 

 

COUNT_LAST 

Obsolete 

Use CTX_QUERY.COUNT_HITS or count(*) to count hits.

See "Counting Hits" in Chapter 6. 

 

FEEDBACK 

Changed 

Procedure name changed to EXPLAIN; procedure behavior unchanged

See "Query Explain Plan" in Chapter 6. 

 

FETCH_HIT 

Obsolete 

In-memory query obsolete.

Use FIRST_ROWS hint in SELECT statement to migrate in-memory queries.

See "Cursor Query" in Chapter 6. 

 

GETTAB 

Obsolete 

Create result tables with CREATE TABLE command.

See Chapter 7, "Document Presentation". 

 

HIGHLIGHT 

Replaced 

HIGHLIGHT replaced by procedures in CTX_DOC (new package)

See "Highlighting" in Chapter 7. 

 

OPEN_CON 

Obsolete 

In-memory query obsolete.

Use FIRST_ROWS hint in SELECT statement to migrate in-memory queries.

See "Cursor Query" in Chapter 6. 

 

PKDECODE 

Obsolete 

Decoding of composite textkeys no longer required, since Oracle returns rowids in cursor queries.

See "Cursor Query" in Chapter 6.  

 

PKENCODE 

Unchanged 

None 

 

PURGE_SQE 

Obsolete 

SQE behavior changed.

See "Stored Query Expressions" in Chapter 6 

 

REFRESH_SQE 

Obsolete 

SQE behavior changed; the system no longer stores results for SQEs.

See "Stored Query Expressions" in Chapter 6 

 

RELTAB 

Obsolete 

Drop result tables with DROP TABLE. 

 

REMOVE_SQE 

Unchanged 

None 

 

STORE_SQE 

Changed 

Stores query definition only. SQE not attached to an index.

See "Stored Query Expressions" in Chapter 6 


Prev Up Next
Oracle
Copyright © 1999 Oracle Corporation.

All Rights Reserved.

Library

Product

Contents

Index