It's neither the udt nor the varchar2.

If you're getting an ora-600 for a simple query like that,
Check the alert log for some info.
If it's nothing you can fix, contact ora support.

- ant

-----Original Message-----
From: BenBart
[mailto:oracledba-ezmlmshield-x43639802.[Email address protected]
Sent: Wednesday, January 04, 2006 9:08 PM
To: LazyDBA Discussion
Subject: ORA-00600

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)





--------
website: http://www.LazyDBA.com
Please don't reply to RTFM questions
Oracle documentation is here: http://tahiti.oracle.com
To unsubscribe: see http://www.lazydba.com/unsubscribe.html
To subscribe: see http://www.lazydba.com
By using this list you agree to these
terms:http://www.lazydba.com/legal.html


Oracle LazyDBA home page