Hi all,

Am getting ORA-00600 if I run

select *
from wf_item_attribute_values
where text_value = 'Element QUANTITY not complete, expected elements ''[UOM]''.'

Just want to know if it is 'coz I have a user-defined type or is it 'coz I have a VARCHAR2(4000)

The table is as follows:

SQL> desc apps.wf_item_attribute_values;
Name Null? Type
----------------------------------------- -------- ----------------------------
ITEM_TYPE NOT NULL VARCHAR2(8)
ITEM_KEY NOT NULL VARCHAR2(240)
NAME NOT NULL VARCHAR2(30)
TEXT_VALUE VARCHAR2(4000)
NUMBER_VALUE NUMBER
DATE_VALUE DATE
EVENT_VALUE APPS.WF_EVENT_T
SECURITY_GROUP_ID VARCHAR2(32)




Oracle LazyDBA home page