Sanjay,

Thanks for the script. It works fine when i go for the normal datatype.

I use Oracle9i and with XMLTYPE datatype.

When i use the script it is not able to UNION the two SQL statements.

It says:

ERROR at line 1:
ORA-22950: cannot ORDER objects without MAP or ORDER method

Could u Pls help on this issue.


Thanks in Advance

gandhi
OCP-DBA