Oracle8i interMedia Text Migration
Release 2 (8.1.6)

Part Number A77061-01

Library

Product

Contents

Index

Go to previous page Go to beginning of chapter Go to next page

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 


Go to previous page Go to beginning of chapter Go to next page
Oracle
Copyright © 1996-2000, Oracle Corporation.

All Rights Reserved.

Library

Product

Contents

Index