Toad World® Forums

Query with xmltable - ORA-00904 or ORA-00936 exception may occur

Toad for Oracle
#1

I get ORA-00904 / ORA-00936 exception in certain situations when SELECT statement uses XMLTABLES operator and the result set contains XMLTYPE columns. The same query works fine in SQL Plus.

I can send you the sample XML files and the queries which produce errors.

#2

Hi Tamas,

Yes, please send SQL and table DDL.

Thanks
John

#3

ok, I sent it offline.

1 Like