Beefy Boxes and Bandwidth Generously Provided by pair Networks
more useful options
 
PerlMonks  

Re^3: Perl, Oracle, and Xquery

by Moron (Curate)
on Mar 07, 2007 at 18:44 UTC ( #603673=note: print w/replies, xml ) Need Help??


in reply to Re^2: Perl, Oracle, and Xquery
in thread Perl, Oracle, and Xquery

It ain't lying. xquery is not an SQL command. As I already explained, you have to extract each PURE SQL statement from your XQuery script before submitting them individually via DBI.

-M

Free your mind

Replies are listed 'Best First'.
Re^4: Perl, Oracle, and Xquery
by jozxyqk (Initiate) on Mar 07, 2007 at 18:50 UTC
    So I need to take the xquery and translate it back into SQL? There's no easier way to just parse xquery naturally in Perl? It doesn't have to be with DBI/DBD.
      I can see a number of ways to interpret that. There is the module Net::MarkLogic::XDBC if you are using xquery as a means to connect to a Marklogic CIS server. But Perl won't just wake up one day and parse the xquery syntax for you - if that module isn't sufficient we'll have to think of some other idea for how to parse it.

      Update: bearing in mind that xquery is of course an XML query language, it might be worth taking a look at the various DBI/XML interfacing modules on offer.

      -M

      Free your mind

        I am using Xquery as a means to connect to an Oracle 10.2g database. My apologies if I did not make myself clear about that in the original post.

        But from your answers, it appears that there is not currently a way to do this in Perl, and nobody has written a module to directly support it. I incorrectly assumed that, since Oracle treats xquery as a subset of SQL, the DBI module would allow it. I guess I will have to go under the covers and find out how/if the xquery translates to SQL and write it all out, or use the Java Saxon libraries instead.

Log In?
Username:
Password:

What's my password?
Create A New User
Domain Nodelet?
Node Status?
node history
Node Type: note [id://603673]
help
Chatterbox?
and the web crawler heard nothing...

How do I use this? | Other CB clients
Other Users?
Others wandering the Monastery: (6)
As of 2022-12-03 18:54 GMT
Sections?
Information?
Find Nodes?
Leftovers?
    Voting Booth?

    No recent polls found

    Notices?