Hi Igor,
Are you using the same version of TDP as me, which is 3.6.1.3294 ?
I don’t think permissions are involved because I’m using the same logon and same database for both TDP and Toad for Oracle. There should be no difference in my permissions when using these applications.
Another user at our site is getting the same error as me, so the issue is not limited to my PC or my logon.
Further testing indicates the problem is related to XMLELEMENT, because the following query (without XMLAGG) gives the same error in TDP as before:
SELECT XMLELEMENT (EMP,lastname)FROM emptest;
I also tried using a database table, rather than my own temp table EMPTEST, and I got the same error.
I also tried deleting my application data directory (after saving a copy) so that I was starting with all defaults. Didn’t help.
Can you suggest anything else I should try? Should I contact support?