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;
[download]

Thank you, that was a much more helpful explanation than the one from Moron. I was not aware of this additional step.

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