Subject:XQuery error on Oracle views Author:Rusty Manesiya Date:22 Feb 2007 04:50 PM
Below is the error I get when I try to execute in Stlyus Studio.
[DataDirect][XQuery]Exception returned by Adaptor (jdbc1) : [DataDirect][XQuery]Error during SQL execution: [Oracle JDBC Driver][Oracle]ORA-01446: cannot select ROWID from, or sample, a view with DISTINCT, GROUP BY, etc.;
There is not much to this.
XQuery Code is below
===========================================================