My Oracle Support Banner

CTX_DOC.SNIPPET fails with errors ORA-29903 ORA-20000 DRG-50857 ORA-01722: invalid number (Doc ID 1381924.1)

Last updated on MARCH 12, 2020

Applies to:

Oracle Text - Version and later
Information in this document applies to any platform.
***Checked for relevance on 26-Nov-2013***


How do we resolve the error below?

SQL> SELECT CTX_DOC.SNIPPET( 'CTIDX_DATEI_1', rowidToChar(ROWID), 'Engagement' )
 FROM artikel_datei d
WHERE CONTAINS( blob_content, 'Engagement' ) > 0
SELECT CTX_DOC.SNIPPET( 'CTIDX_DATEI_1', rowidToChar(ROWID), 'Engagement' )
FEHLER in Zeile 1:
ORA-29903: error in executing ODCIIndexFetch() routine
ORA-20000: Oracle Text error:
DRG-50857: oracle error in drvdoc.get_rowid
ORA-01722: invalid number
ORA-06512: at "CTXSYS.DRUE", line 160
ORA-06512: at "CTXSYS.CTX_DOC", line 1297
ORA-06512: at line 1


To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!

In this Document

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.