Oracle OSB - XQuery - line 7, col 2: {err}FORG0005: expected exactly 1 item, got 0

I am trying to execute the below sample XQuery. Eclipse designer does not show any error. However on executing the XQuery, I get the following error "Error executing the XQuery transformation: line 7, column 2: {err}FORG0005: expected exactly one item, got 0 items". Appreciate your help. xquery vers ...

Oracle XQuery error during replace action is OSB

Hi, I'm trying to replace the body in the OSB with a xquery but its seems i have a typing issue somewhere.....or namespaces but I can't figure it out. The error I get is:OSB Replace action failed updating variable "body": Error parsing XML: {err}XP0006: "element {http://www.w3.org/200 ...

Oracle DetailsRecords.xsd to HeaderAndDetails.xsd XQuery Transformation for OSB

Can any body provide XQuery transformation between schema A and Schema B, I am getting issues while creating the transformation. Sample Scenario================Source Schema A contains schema for details Table.Target Schema B contains schema for Header and Details.As you can see Schema A doesnt cont ...

Oracle OSB - XQuery - line 24, col 1 {err}FORG0005: expected 1 item, got 2 or mor

In the below XQ, I am trying to learn making calls to local functions. I have tweaked my earlier XQ, which had a local variable defined [in xf:getCost() function] as XPath to Quantity. Now, I have modified the XQ to make a call to xf:getQty() from xf:getCost(), to get the desired Quantity.On executi ...

Oracle OSB XQuery transformation help in Proxy Service

Need help in transformation of the below input to a proxy service <soapenv:Body xmlns:soapenv="http://schemas.xmlsoap.org/soap/envelope/"> <InputParams> <queryParams> <quer:query-params xmlns:quer="http://www.example.org/QueryParams"> <param name=" ...

Oracle For-Each loop in OSB

i was trying to use the for-each loop in OSB.My for-each look like this:For Each variable in ./Extract/State... ./Extract/State_Change of variable * Indexed by variable with total count in variable Do ( Assign XQuery: Recieve... XQuery Resource: to variable transformedState Replace ./Extract/State_C ...

Oracle REST using OSB: Unable to modify $outbound parameters

I'm building a OSB Service to interact with the Google Stock API and here's what I have:Oracle Service Bus 11.1.1.5. on WLS 10.3.5.Business Service that has the following configuration: Service Type: Messaging ServiceRequest Message Type: NoneResponse Message Type: TextProtocol: httpHTTP Request Met ...

Oracle Timestamp in xquery

How to get current timestamp in xquery.I am using OSB and created a list file jca adapter. I get a xml data with file names and last modified time when I execute the business service that includes the list file adapter.I want to compare this timestamp with current system time.How I can do this ? ...

Oracle remove namespace,xml tag in OSB

OSB In Proxy Service:Once I get response from Business Service 1, I need to send that as request to Business Service 2.Business Service 1 response xml is <Reference>123</Reference>Business Service 2 request xml should be <ReferenceId>123</ReferenceId> Now, in my Proxy I used ...

Oracle XQuery error due to upgrade to newer version

I'm currently migrating some services from an old ALSB configuration to a new OSB configuration.The strange thing is when I migrate services with XQuery scripts several of these scripts give following error on import:line xx, column xx: {err}XP0051: "{http://www.w3.org/2001/XMLSchema}anyType": type ...

Oracle Help with complex XQuery tranformation

I posted this message in SOA category but I think it makes sense to post it here also.I have to write a complex XQuery tranformation for storing a XML document in database using a database adapter in Oracle Service Bus (transformation is from source document schema to database adapter schema).I am h ...

Oracle Regarding OSB dvm

I was trying to use the dvm in OSB.At run time i could see that i am getting null values for the username and password. You could see below the xquery transformation where i am using my dvm. Can anyone let me know is there any issue in dvm usage in this xquery. I could see that rest of the things ar ...

Oracle How to add special characters (Extended ASCII charaters) in XQuery

I have to build an OSB component, which writes to a MQ. The file that has to be written in the MQ (which is read by a mainframe system) requires some 'Extended ASCII codes' to be hardcoded (or sent) as a part of the file.Is there any XQuery function that we can use to ad these special characters in ...

Oracle Replacing default namespace in OSB message flow

I'm in the process of setting up a simple OSB proxy and could use some help figuring out how to change a default namespace in the response from the business service.The proxy and business service use different namespaces which we'll call "http://foo.com/namespace/proxy" and "http://foo.com/namespace ...

Webcast - XQuery

For those interested in XQuery ... http://webevents.broadcast.com/ibm/i...ex.asp?loc=163My registration confirmation reads ; Thank you for registering for the "XQuery: A Query Language for XML" Insight Exchange Technology Webcast which airs live Wednesday, September 03, 2003 11:00 a.m. - 1 ...

Oracle Xquery Prototype new release is not the new release expected

On the Xml XQuery site (http://technet.oracle.com/sample_code/tech/xml/xmldb/xmldb_xquerydownload.html) There is an announcement for a new release (RELEASE_0.2_030121) of The XmlQuery prototype. Sadly the only download accessible is still the old one (RELEASE_0.1_020319).Can anybody correct the link ...

Oracle Xquery download not new ?!!

the dowload on http://otn.oracle.com/sample_code/tech/xml/xmldb/xmldb_xquerydownload.html--> Download Oracle XQuery prototype (for windows)is not the new version !! ...

Doing "LIKE" with xquery..?

guys. I'd like to use xquery to extract some data from an xml column. I need to filter the records on the content of some tags in the same manner as the standard LIKE clause. Basically, how would I tansform the following query...PHP Code: select unitID, XMLQUERY('for $e in $ ...

Xquery declare namespace returns error

on DB2 v9.5 fp2 on Linux I would like to declare namespace in Xquery. I wrote the following code:XQUERY declare namespace ns1="http://data.si.snt.eu" But got the following error:SQL16002N An XQuery expression has an unexpected token ""http://data.si.snt.eu"" following ...

Unable to download Oracle XQuery Prototype

I have been trying to download the Oracle XQuery Prototype but the link fails everytime. This is the URL:http://www.oracle.com/technology/sample_code/tech/xml/xmldb/xmldb_xquerydownload.htmlCan anyone provide me with the xq.zip? ...

XSLT vs. XQuery

I was hoping to see an example on how a piece of XSLT would look like when using XQuery instead.I have been searching the Web like a maniac but not found any decent example and I would really love it if anyone here could show one.The easier it is the better. For example it could only include a if st ...

Problem with OJXQI - The Oracle Java XQuery API

Oracle Server Version: 9.2.0.3.0I have installed the oracle xdk kit and oracle xquery package.I created one table of XMLTYPE and inserted an xmldocument in the table.Now using OJXQI, I am trying to query the database with the following xquery in my java program:"let $O := sqlquery(\"select ...

Tutorial by Don Chamberlin on XQuery

Xquery: A Query Language for XML Webcast September 3Speaker: Dr. Don Chamberlin, IBM Almaden Research CenterDate: September 3Time: 1 1-12:30 ET, 4-5:30 GMTSign up today at:http://webevents.broadcast.com/ibm/insightexchange/090303/index.asp?loc=163 ...

How can i get oracle 10g and Xquery

sir,How can i download Oracle 10g and Xquery.I need it urgently for my project work... ...

Free Webcast about XQuery

There is a free 1-hour Webcast about XQuery next Monday. It will cover the XQuery language and its future direction. For more information and to register for the Webcast, go to the following URL...XQuery: Introduction, Tips, and Future DirectionsNov 17, 20082:00 p.m. Eastern / 11:00 a.m. Pacific (60 ...

New to XQuery, help needed

1) I have to submit some XML queries for my college work.How to return multiple rows in XQuery?for $x in doc("India.xml")/India/statewhere $x/language="Hindi"return<state> $x/state_name </state>,<language> $x/language </language>returns<state> $x/sta ...

Slow xpath/xquery performance

Using an older version of DB2 9.5 (from 2007) without fix 1...Getting slow performance with xquery statements (xmlexists part the where clause). Have a generic table called Element with an XML column called CONFIGURATION. The total amount of data currently in the table is 40328 records. The Element ...

XQuery or XPAth on Courses.xml

I created a courses.xml file and I want to find the answers for following queries.I am new to xml so I want to know how I can do it.I want to use Xpath or Xquery. Here is the queries i want to find:1-How can I find find the TA of the network courses that listed in CS department,taught in spring seme ...

Xquery question

Is there any difference with Xquery for a regular XML document as opposed to a XSD file? I am playing with Liquid XML Studio and it seems like it is different. ...

how to filter rss feed using XQuery-FLWOR?

"Find a feed that you like. Use XQuery to filter the feed. The result from the filtering should either by valid (X)HTML or a new feed."Could anybody help me??? Please... ...

XQuery FLOWR + HTML

I want to get the info out of an external XML file using an XQuery FLOWR exprssion. I have something in my code that looks like:<div id="klassement"><h3>klassement_hvvb1</h3><ul>{for $x in doc("http://www.volleyvvb.be/XML/rangschikking_xml.php")/klassement ...

xslt+xquery

folks i have a sample xml file <books><book><author>henry</author><publisher>joe</publisher><year>2006</year></book><book><author>martin</author><publisher>tom</publisher><year>2004</year></book> ...

Getting XQuery to work?

I have just installed DB2 Express 9.5. When I use XPath expression in XQuery, the result is always "1" no matter what I type. When I just return the xml column as it is, all is fine.I remember that this happens when XPath is disabled but I dont know where to enable it. Please help. ...

xQuery help!

i am newbie to xquery. i am having this problem with my simple xquery. I am using eXist XML DB and using this query in PHP to retrieve result. this is my xml database file. <class><result><student>abc</student><grade>4</grade></result><result><stude ...

VML and XQUERY?

---------------------Client Specifications:---------------------Browser: IE5+Uses Microsoft Vector Markup Language (VML) and JavascriptI am working on an application that uses vml extensively and client side javascript to position these vml elements.There are too many vml elements in the web page th ...

xml/xquery/output format?

I have just begun playing... NOVICE! But, I have an xml document in-which I am using xquery to create a list of names. With the names in the list I have a check box next to each name. I would like to use css or xsl to create 3 vertical columns of about 9 rows each. Do I right the css in the actual x ...

a function in XQuery to get the XML file name please?

Anyone who knows a XQuery function which can get the .xml file name from which contents come from? Since I need to link the corresponding xml file after I extract information from it.Many ...

XML XQuery

I'm very new to XQuery and need help.I have xml document eg<catalog><author><name> Tom Brown</name><book>example</book><book>example2</book></author> <author><name> John Smith</name><book>example3</book><book>e ...

heredoc syntax .. xquery string causes error

I am trying to use heredoc to introduce XQuery strings (then to apply urlencode before submitting querystring as a SOAP parameter)Following the rules here ..http://www.php.net/manual/en/language.types.string.php#language.types.string.syntax.heredocI can get simple strings to go into heredoc ..but mo ...

Oracle OSB 10gR3 Dev Certification

I have been looking through the certification details and cannot seem to find the certification I require. I would like to become certified as an OSB 10g Developer creating proxy services and message flows. Can anyone please point me in the right direction? ...

Update a table using result of an XQuery

I want to insert the result of an XQuery into an XML column of a table. I was trying to do this but in vain. In SQL such a thing is simple and can be done as:insert into TABLE1(A, B) (select A, B from TABLE2)I have a table named XMLTEST which has two attributes: id and DATA. id is integer and DATA i ...

XQuery support

I hope someone can help me. I'd like to know to what extent DB2 supports XQuery 1.0? ...

Free Webcast about XQuery

There is a free 1-hour Webcast about XQuery next Monday. It will cover the XQuery language and its future direction. For more information and to register for the Webcast, go to the following URL...XQuery: Introduction, Tips, and Future DirectionsNov 17, 20082:00 p.m. Eastern / 11:00 a.m. Pacific (60 ...

XQuery Updating Expressions: A Question on Parameter Markers

XQuery updating expressions are really useful for making partial updates to XML documents. If there is no support in XQuery for parameter markers, how can I make use of this feature very effectively in my java applications (that use JDBC Type-4 driver directly or pureQuery APIs)?For easy understandi ...

Undefined name with simple XQUERY

I'm new to DB2 and PureXML, but I've installed a DB, created a simple XML table imported data and would like to do some testing, unfortunately I keep getting "SQL0204N" error "blah.blah" is an undefined name.create table vehicle ( seriesid varchar(16) NOT NULL, modelid varchar(16) NOT NULL, vdoc xml ...

XQUERY syntax needed to add target encoding

The Xquery is equivalent to the SQL query SELECT FR_DOC FROM FR_2008. I can run the sql select statement but not the XQUERY below. Commands Entered XQUERY db2-fn:xmlcolumn ('FR_2008.FR_DOC'); XQUERY db2-fn:xmlcolumn ('FR_2008.FR_DOC')FR_DOC SQL20412N Serialization of an XML value resulted in charact ...

Support for user-defined XQuery functions

When will DB2 pureXML's implementation of XQuery support the ability to create user-defined XQuery functions? ...

Need help with aggregating XQuery with access to relational columns

I can't figure this out, and also can't decide whether this makes sense or whether it's better to just execute simple XMLTABLE and then convert back to desired XML structure using Java afterwards.For my requirement, I have a relational table that contains a few regular columns and one XML column.SQL ...

Need help with XQuery

I'm trying to create an update XQuery where one of the parameters is a piece of XML. Before the update occurs, that piece of XML needs to be modified. For example, the parameter parm1 may contain "<foo>bar</foo>" but I need to update it to include an attribute, such as "<foo id="1" ...

XQuery 1.1 support

I've been testing some queries with the XQuery Whiteboard tool. When comparing distinct-values syntax for grouping, the 1.1 'group by' syntax is many times faster.Since DB2 does not currently support XQuery 1.1, by goal is to embed the whiteboard query processing engine in my Java application. Unfor ...