Oracle8i interMedia Text Migration Release 8.1.5 A67845-01 |
|
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:
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 |
|
|
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 |
|
|
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 |
2.x Package | Procedure | Status | Migration Notes |
---|---|---|---|
CTX_INFO |
GET_INFO |
Obsolete |
CTX_INFO package obsolete. |
GET_STATUS |
Obsolete |
||
GET_VERSION |
Obsolete |
2.x Package | Procedure | Status | Migration Notes |
---|---|---|---|
CTX_LING |
CANCEL |
Obsolete |
CTX_LING package obsolete; Services queue obsolete; settings labels obsolete:
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 |
|
2.x Package | Procedure | Status | Migration Notes |
---|---|---|---|
CTX_QUERY |
CLOSE_CON |
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 |
Use FIRST_ROWS hint in SELECT statement to migrate in-memory queries. See "Cursor Query" in Chapter 6. |
|
GETTAB |
Obsolete |
|
|
HIGHLIGHT |
Replaced |
HIGHLIGHT replaced by procedures in CTX_DOC (new package) See "Highlighting" in Chapter 7. |
|
OPEN_CON |
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 |
|
|
REFRESH_SQE |
Obsolete |
SQE behavior changed; the system no longer stores results for SQEs. |
|
RELTAB |
Obsolete |
Drop result tables with DROP TABLE. |
|
REMOVE_SQE |
Unchanged |
None |
|
STORE_SQE |
Changed |