Using doc() with Oracle 10g

Hi, whenever I use doc() function in XQuery executed by Oracle I'm getting the following error message: Engine name: Oracle on localhost Severity: error Description: java.sql.SQLException: ORA-19109: RETURNING keyword expected - ORA-19109: RETURNING keyword expected But when I run the same query directly from sqlplus utility, everything works. Error is emitted even for very simplistic usages of doc() function like doc('/home/SCOTT/katalog/katalog.xml') (where /home/SCOTT/katalog/katalog.xml is path to resource stored inside Oracle XML DB Repository) Is there any way how to make doc() function work directly from Oxygen? Accessing XML content by other means like using ora:view() works corretly. I'm using oXygen 10.2 and Oracle 10.2. Thanks, Jirka -- ------------------------------------------------------------------ Jirka Kosek e-mail: jirka@kosek.cz http://xmlguru.cz ------------------------------------------------------------------ Professional XML consulting and training services DocBook customization, custom XSLT/XSL-FO document processing ------------------------------------------------------------------ OASIS DocBook TC member, W3C Invited Expert, ISO JTC1/SC34 member ------------------------------------------------------------------

Jirka Kosek wrote:
Error is emitted even for very simplistic usages of doc() function like
doc('/home/SCOTT/katalog/katalog.xml')
Errr, developers of Oracle database should be cruelly tortured. When I enclose path in "" instead of '' it works. So problem is probably in Oracle itself not in a way how oXygen passed query. It is real pain to work with XQuery in Oracle when one is used to conforming implementations like Saxon :-( Jirka -- ------------------------------------------------------------------ Jirka Kosek e-mail: jirka@kosek.cz http://xmlguru.cz ------------------------------------------------------------------ Professional XML consulting and training services DocBook customization, custom XSLT/XSL-FO document processing ------------------------------------------------------------------ OASIS DocBook TC member, W3C Invited Expert, ISO JTC1/SC34 member ------------------------------------------------------------------
participants (1)
-
Jirka Kosek