Oracle | DBMS_SEARCH

Oracle DBMS_SEARCH_DEF Version 26ai

General Information

Library Note

Morgan's Library Page Header

The best Oracle News for FY2026

Oracle Database 26ai is now availble. If you haven't you downloaded already: Why?

Purpose Undocumented

AUTHID DEFINER

Dependencies

DBMS_AQADM	DBMS_STANDARD	DRUE
DBMS_ASSERT	DR$DBMS_SEARCH_INDEX	DRVUTL
DBMS_SCHEDULER	DR$DBMS_SEARCH_INDEX_SOURCE	DR_DEF
DBMSSEARCH

Documented No

Exceptions

Error Code	Reason
ORA-06510	PL/SQL: unhandled user-defined exception

First Available 23ai

Pragmas PRAGMA SUPPLEMENTAL_LOG_DATA(default, NONE);

Security Model Owned by CTXSYS with no privileges granted.

Source {ORACLE_HOME}/ctx/admin/dbmssearchdef.pkh
{ORACLE_HOME}/ctx/admin/dbmssearchdef.pkb

Subprograms

CREATEQUEUE	DROPTRIGGER
CREATESEARCHINDEXSYNCJOB	GETNEXTSOURCEID
CREATESEQUENCE	GETSEARCHINDEXCURSOR
CREATETABLETRIGGER	GETSOURCEID
CREATEVIEWTRIGGER	INSERTSEARCHINDEXMETADATA
DELETESEARCHINDEXMETADATA	LOCKSYNCINDEX
DROPQUEUE	SEARCHINDEXEXISTS
DROPSEARCHINDEXSYNCJOB	UNLOCKSYNCINDEX
DROPSEQUENCE

CREATEQUEUE (new 23ai)

Undocumented dbms_search_def.createQueue(queue_pfx IN VARCHAR2);

TBD

CREATESEARCHINDEXSYNCJOB (new 23ai)

Undocumented dbms_search_def.createSearchIndexSyncJob( job_pfx IN VARCHAR2, index_name IN VARCHAR2, source_name IN VARCHAR2, source_id IN NUMBER);

TBD

CREATESEQUENCE (new 23ai)

Undocumented dbms_search_def.createSequence(sequence_pfx IN VARCHAR2);

exec ctxsys.dbms_search_def.createSequence('SYS_AI');

           *

      ORA-06510: PL/SQL: unhandled user-defined exception

CREATETABLETRIGGER (new 23ai)

Undocumented dbms_search_def.createTableTrigger( trigger_name IN VARCHAR2, source_namennn IN VARCHAR2, json_object_new IN VARCHAR2, json_object_old IN VARCHAR2, pfx IN VARCHAR2);

TBD

CREATEVIEWTRIGGER (new 23ai)

Undocumented dbms_search_def.createViewTrigger( trigger_name IN VARCHAR2, table_name IN VARCHAR2, query_text IN VARCHAR2, pfx IN VARCHAR2);

TBD

DELETESEARCHINDEXMETADATA (new 23ai)

Undocumented dbms_search_def.deleteSearchIndexMetadata( c_index_owner IN VARCHAR2, c_index_name IN VARCHAR2, c_source_owner IN VARCHAR2 DEFAULT NULL, c_source_name IN VARCHAR2 DEFAULT NULL);

TBD

DROPQUEUE (new 23ai)

Undocumented dbms_search_def.dropQueue(queue_pfx IN VARCHAR2);

TBD

DROPSEARCHINDEXSYNCJOB (new 23ai)

Undocumented dbms_search_def.dropSearchIndexSyncJob(job_pfx IN VARCHAR2);

TBD

DROPSEQUENCE (new 23ai)

Undocumented dbms_search_def.dropSequence(sequence_pfx IN VARCHAR2);

exec dbms_search_def.dropSequence('TESTSEQ');

DROPTRIGGER (new 23ai)

Undocumented dbms_search_def.dropTrigger(triggername IN VARCHAR2);

TBD

GETNEXTSOURCEID (new 23ai)

Undocumented dbms_search_def.getNextSourceID(sequence_name IN VARCHAR2) RETURN NUMBER;

TBD

GETSEARCHINDEXCURSOR (new 23ai)

Undocumented dbms_search_def.getSearchIndexCursor( c_index_owner IN VARCHAR2, c_index_name IN VARCHAR2) RETURN sys_refcursor;

TBD

GETSOURCEID (new 23ai)

Undocumented dbms_search_def.get_SourceID( c_index_owner IN VARCHAR2, c_index_name IN VARCAR2, c_source_owner IN VARCHAR2, c_source_name IN VARCHAR2, c_source_type IN OUT VARCHAR2) RETURN NUMBER;

TBD

INSERTSEARCHINDEXMETADATA (new 23ai)

Undocumented dbms_search_def.insertSearchIndexMetadata( c_index_owner IN VARCHAR2, c_index_name IN VARCHAR2, c_source_owner IN VARCHAR2 DEFAULT NULL, c_source_name IN VARCHAR2 DEFAULT NULL, c_source_type IN VARCHAR2 DEFAULT NULL, c_source_id IN NUMBER DEFAULT 0);

TBD

LOCKSYNCHINDEX (new 23ai)

Undocumented dbms_search_def.lockSyncIndex( idxid IN NUMBER, srcid IN NUMBER) RETURN VARCHAR2;

TBD

SEARCHINDEXEXISTS (new 23ai)

Undocumented dbms_search_def.searchIndexExists( c_index_owner IN VARCHAR2, c_index_name IN VARCHAR2, c_source_owner IN VARCHAR2, c_source_name IN VARCHAR2, c_source_type IN VARCHAR2) RETURN BOOLEAN;

TBD

UNLOCKSYNCINDEX (new 23ai)

Undocumented dbms_search_def.unlockSyncIndex(lock_handle IN VARCHAR2);

TBD