[oXygen-user] Using doc() with Oracle 10g

[Jirka Kosek]

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:       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
------------------------------------------------------------------

-------------- next part --------------
A non-text attachment was scrubbed...
Name: signature.asc
Type: application/pgp-signature
Size: 250 bytes
Desc: OpenPGP digital signature
Url : http://www.oxygenxml.com/pipermail/oxygen-user/attachments/20090517/f984a682/attachment.bin