http://www.perlmonks.org?node_id=603661

jozxyqk has asked for the wisdom of the Perl Monks concerning the following question:

Hello Monks,

I am working with an Oracle database and accessing it through Xquery. So far, I have been doing this just through the SQLPlus tool. But now I need to programmatically access it, and I don't want to have to resort to Java.

In SQLPlus, I simply have to enter the line "xquery", and then insert my xquery script below that.

But when I try to use Perl DBI to "prepare" such a statement, I get an "Invalid SQL" error.

How can I access an Oracle database using Xquery in Perl?

Thanks.