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 will be available on generic Linux platforms in January and soon on AIX and Windows

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