|P is for Practical|
Perl, Oracle, and Xqueryby jozxyqk (Initiate)
|on Mar 07, 2007 at 18:15 UTC||Need Help??|
jozxyqk has asked for the wisdom of the Perl Monks concerning the following question:
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?