A
PL/SQL Changes

This appendix describes the changes to pre-8.1.5 PL/SQL packages and procedures. The tables in this appendix include packages and procedures that are obsolete in 8.1.5.

This appendix describes only changes to pre-8.1.5 packages and procedures. It does not list new packages and procedures for 8.1.5.

See Also: For a complete list of all the procedures and packages in interMedia Text 8.1.5 including the new ones, see the Oracle8i interMedia Text Reference.

The following topics are covered:

• CTX_ADM Package

• CTX_DML Package

• CTX_DDL Package

• CTX_INFO Package

• CTX_LING Package

• CTX_QUERY Package

• CTX_SVC Package

• CTX_THES Package

CTX_ADM Package

2.x Package	Procedure	Status	Migration Notes
CTX_ADM	CHANGE_MASK	Obsolete	Server runs only as M personality. See Oracle8i interMedia Text Reference
	GET_QUEUE_STATUS	Obsolete	All queues, except DML queue obsolete. DML queue status (Enabled or Disabled) cannot be changed.
	RECOVER	Unchanged	None
	SET_QUERY_BUFFER_SIZE	Obsolete	Query pipe obsolete. Queries processed by Oracle.
	SHUTDOWN	Unchanged	None
	UPDATE_QUEUE_STATUS	Obsolete	All queues, except DML queue, obsolete. DML queue status (Enabled or Disabled) cannot be changed

CTX_DML Package

2.x Package	Procedure	Status	Migration Notes
CTX_DML	REINDEX	Changed	CTX_DML package obsolete. REINDEX moved to CTX_DOC (new package).
	SYNC	Obsolete	Use SQL command, ALTER INDEX ... REBUILD, to manage DML in Text indexes See "Updating the Index - Batch DML" in Chapter 5.
	SYNC_QUERY	Obsolete

CTX_DDL Package

2.x Package	Procedure	Status	Migration Notes
CTX_DDL	ADD_SECTION	Changed	New section types. Specify only section start tag. See "Document Sections" in Chapter 5.
	CLEAR_ATTRIBUTES	Obsolete	Use CTX_DDL.UNSET_ATTRIBUTE. See Oracle8i interMedia Text Reference
	CREATE_INDEX	Obsolete	Use SQL command, CREATE INDEX, to create Text indexes. See "Creating an Index" in Chapter 5.
	CREATE_POLICY	Obsolete	Policies obsolete. Create indexes directly for a text column.
	CREATE_PREFERENCE	Changed	New method for creating preferences. See "Creating Preferences" in Chapter 5.
	CREATE_SECTION_GROUP	Changed	Specify section group name and section group type. See"Document Sections" in Chapter 5.
	CREATE_SOURCE	Obsolete	Use SQL*Loader to load text.
	CREATE_TEMPLATE_POLICY	Obsolete	Policies obsolete. Create indexes directly for a text column
	DROP_INDEX	Obsolete	Use SQL command, DROP INDEX, to drop Text indexes
	DROP_INTTRIG	Obsolete	Deleting DML triggers no longer supported
	DROP_POLICY	Obsolete	Policies obsolete. Create indexes directly for a text column.
	DROP_PREFERENCE	Unchanged	None
	DROP_SECTION_GROUP	Unchanged	None
	DROP_SOURCE	Obsolete	Text loading no longer supported through ctxload - use SQL*Loader
	OPTIMIZE_INDEX	Obsolete	Use SQL command, ALTER INDEX ... REBUILD, to optimize Text indexes. See "Optimizing an Index" in Chapter 5.
	REMOVE_SECTION	Changed	New types of sections. See Oracle8i interMedia Text Reference
	RESUME_FAILED_INDEX	Obsolete	Use SQL command, ALTER INDEX .. REBUILD, to resume indexing operation. See "Resuming Failed Index" in Chapter 5.
CTX_DDL cont.	SET_ATTRIBUTE	Changed	New method for creating preferences See "Creating Preferences" in Chapter 5.
	UPGRADE_INDEX	Obsolete	None. You must recreate indexes must for migration.
	UPDATE_POLICY	Obsolete	Policies obsolete. You create indexes directly for a text column.
	UPDATE_SOURCE	Obsolete	Text loading no longer supported through ctxload - use SQL*Loader

CTX_INFO Package

2.x Package	Procedure	Status	Migration Notes
CTX_INFO	GET_INFO	Obsolete	CTX_INFO package obsolete.
	GET_STATUS	Obsolete
	GET_VERSION	Obsolete

CTX_LING Package

2.x Package	Procedure	Status	Migration Notes
CTX_LING	CANCEL	Obsolete	CTX_LING package obsolete; Services queue obsolete; settings labels obsolete: Gist and theme generation performed synchronously; errors returned directly to requestor REQUEST_GIST and REQUEST_THEMES moved to CTX_DOC (new package) and renamed (GIST and THEMES) CTX_DOC.GIST include arguments for specifying Gist size settings. CTX_DOC.THEMES include arguments for full theme output. See "Obtaining List of Themes, Gists, and Theme Summaries" in Chapter 7.
	GET_COMPLETION_CALLBACK	Obsolete
	GET_ERROR_CALLBACK	Obsolete
	GET_FULL_THEMES	Obsolete
	GET_LOG_PARSE	Obsolete
	GET_SETTINGS_LABEL	Obsolete
	REQUEST_GIST	Obsolete
	REQUEST_THEMES	Obsolete
	SET_COMPLETION_CALLBACK	Obsolete
	SET_ERROR_CALLBACK	Obsolete
	SET_FULL_THEMES	Obsolete
	SET_LOG_PARSE	Obsolete
	SET_SETTINGS_LABEL	Obsolete
	SUBMIT	Obsolete

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

CTX_SVC Package

2.x Package	Procedure	Status	Migration Notes
CTX_SVC	CANCEL	Obsolete	CTX_SVC package obsolete; Services queue obsolete: Gist and theme generation performed inline; errors returned directly to requestor Index errors reported through new view, CTX_INDEX_ERRORS.
	CANCEL_ALL	Obsolete
	CANCEL_USER	Obsolete
	CLEAR_ALL_ERRORS	Obsolete
	CLEAR_ERROR	Obsolete
	CLEAR_INDEX_ERRORS	Obsolete
	CLEAR_LING_ERRORS	Obsolete
	REQUEST_STATUS	Obsolete

CTX_THES Package

2.x Package	Procedure	Status	Migration Notes
CTX_THES	CREATE_PHRASE	Changed	CREATE_PHRASE is no longer a function. It is now a procedure that must be called in the same manner as other PL/SQL procedures. The syntax for CREATE_PHRASE remains unchanged.
	CREATE_THESAURUS	Changed	CREATE_THESAURUS is no longer a function. It is now a procedure that must be called in the same manner as other PL/SQL procedures. The syntax for CREATE_THESAURUS remains unchanged.
	DROP_THESAURUS	Unchanged	None

---