Oracle Text (MOSC)

MOSC Banner

How to catch DRG errors dealing with Oracle Text

edited Dec 16, 2018 4:04AM in Oracle Text (MOSC) 3 commentsAnswered

Dear Folks,

I want to know how to catch exceptions using DRG error code when dealing with Oracle text.

e.g.

BEGIN

   Ctx_Ddl.Create_Preference('MY_SEARCH_STORAGE', 'BASIC_STORAGE');

END;

When 'MY_SEARCH_STORAGE' preference already exists, the above code segment raises the below error.

ORA-20000: Oracle Text error:

DRG-10701: preference USER1.MY_SEARCH_STORAGE already exists

ORA-06512: at "CTXSYS.DRUE", line 171

ORA-06512: at "CTXSYS.DRVLSB", line 19

ORA-06512: at "CTXSYS.CTX_DDL", line 23

ORA-06512: at line 2

I know we can easily catch ORA-20000 but is there a way that we can catch DRG-10701?

Thanks

Navinth

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

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

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center