hi,

Im afcing a strange problem with xmlsequence function in 10g database.

c the query

select xmltype.extract(value(t), '//SL_NO/text()').getstringval() as sl
from t_employee,
table(xmlsequence( extract( c_xml,'/EMPLOYEE/E_DATA' ) ) ) t)

when im executing this
im getting

PL/SQL: ORA-00904: invalid column name
and ponting to xmlsequence.

but the same thing im able to run in 9i database.

any suggestion??