XML Editor
Sign up for a WebBoard account Sign Up Keyword Search Search More Options... Options
search
Chat Rooms Chat Help Help News News Log in to WebBoard Log in Not Logged in
Home » Boards » Stylus Studio Developer Network » XQuery Help and Discussion » XQuery error on Oracle views
Show tree view Topic
Go to previous topicPrev TopicGo to next topicNext Topic
Postnext
Rusty ManesiyaSubject: 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
===========================================================

declare namespace a = "http://www.test.org/schema/AP/party";
declare namespace b = "http://www.test.org/schema/AP/core";

<a:listOfParty>
{
for $PERSON_VIEW in collection("AP_TEST.PERSON_VIEW")/PERSON_VIEW
where $PERSON_VIEW/GIVENNAME = "John"
return
<a:party>
<a:id>
{$PERSON_VIEW/ID/text()}
</a:id>
<a:typeCode>
{$PERSON_VIEW/TYPECODE/text()}
</a:typeCode>
<a:name>
<b:variableNameData>
<b:variableName>
{$PERSON_VIEW/FULLNAME/text()}
</b:variableName>
</b:variableNameData>
</a:name>
<a:name>
<b:variableNameData>
<b:variableName>
{$PERSON_VIEW/GIVENNAME/text()}
</b:variableName>
</b:variableNameData>
</a:name>
<a:name>
<b:variableNameData>
<b:variableName>
{$PERSON_VIEW/FAMILYNAME/text()}
</b:variableName>
</b:variableNameData>
</a:name>
<a:description>
{$PERSON_VIEW/DESCRIPTION/text()}
</a:description>
</a:party>
}
</a:listOfParty>

Postnext
Ivan PedruzziSubject: XQuery error on Oracle views
Author: Ivan Pedruzzi
Date: 22 Feb 2007 05:23 PM
Hi Rusty,

Could you please tell us which Oracle version are you running?

Thank you
Ivan Pedruzzi
Stylus Studio Team
Postnext
Ivan PedruzziSubject: XQuery error on Oracle views
Author: Ivan Pedruzzi
Date: 22 Feb 2007 05:37 PM

I forgot to ask you, which Stylus Studio build are you running?

Thank You
Ivan Pedruzzi
Stylus Studio Team
Postnext
Rusty ManesiyaSubject: XQuery error on Oracle views
Author: Rusty Manesiya
Date: 23 Feb 2007 08:03 AM
I am using XML Enterprise Edition 2006, release 3
The Framework version is 653g

JVM is
1.5.0_08-b03 Java HotSpot(TM) Client VM Sun Microsystems Inc.
debug mode port:8000

Oracle 10g
Posttop
Ivan PedruzziSubject: XQuery error on Oracle views
Author: Ivan Pedruzzi
Date: 23 Feb 2007 08:37 AM

Rusty,

We believe that the problem you are experiencing has been fixed in DataDirect XQuery 2.0 SP1.

Could you please download Stylus Studio 2007 Enterprise trial and try?


Thank you
Ivan Pedruzzi
Stylus Studio Team
 
Go to previous topicPrev TopicGo to next topicNext Topic
Download A Free Trial of Stylus Studio 6 XML Professional Edition Today! Powered by Stylus Studio, the world's leading XML IDE for XML, XSLT, XQuery, XML Schema, DTD, XPath, WSDL, XHTML, SQL/XML, and XML Mapping!  
go

Log In Options

Site Map | Privacy Policy | Terms of Use | Trademarks
Stylus Scoop XML Newsletter:
W3C Member
Stylus Studio® and DataDirect XQuery ™are from DataDirect Technologies, is a registered trademark of Progress Software Corporation, in the U.S. and other countries. © 2004-2016 All Rights Reserved.