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

Last updated on FEBRUARY 08, 2017

Applies to:

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

Goal

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

Solution

Sign In with your My Oracle Support account

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

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms