Beefy Boxes and Bandwidth Generously Provided by pair Networks
Keep It Simple, Stupid
 
PerlMonks  

Re^3: Perl, Oracle, and Xquery

by varian (Chaplain)
on Mar 07, 2007 at 19:05 UTC ( #603683=note: print w/replies, xml ) Need Help??


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

"XQUERY" is a command to set a mode in the SQL interpreter SQL*Plus. So it is not send to the backend database engine.
Once you have set XQUERY mode then the following statement ('.....') will be embedded in a SELECT XQUERY statement by SQL*Plus before it is send to the database engine.

So if you would want to do something similar from within Perl you would need to enter in your prepare method a text like this:

SELECT XQUERY('......' RETURNING CONTENT) FROM dual;
NB: xquery SQL extensions are not supported by all databases

Replies are listed 'Best First'.
Re^4: Perl, Oracle, and Xquery
by jozxyqk (Initiate) on Mar 07, 2007 at 19:26 UTC
    Thank you, that was a much more helpful explanation than the one from Moron. I was not aware of this additional step.

Log In?
Username:
Password:

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

How do I use this? | Other CB clients
Other Users?
Others rifling through the Monastery: (3)
As of 2022-09-26 03:58 GMT
Sections?
Information?
Find Nodes?
Leftovers?
    Voting Booth?
    I prefer my indexes to start at:




    Results (116 votes). Check out past polls.

    Notices?