1 2 3 4 5 6 7 | export ORACLE_BASE=/u01/app/oracleexport FMW_HOME=$ORACLE_BASE/Middleware/11.1.1export ORACLE_COMMOD=$FMW_HOME/oracle_common/modulesexport XDK_HOME=$ORACLE_COMMOD/oracle.xdk_11.1.0export NLSRTL_HOME=$ORACLE_COMMOD/oracle.nlsrtl_11.1.0export CLASS_PATH=$XDK_HOME/xquery.jar:$XDK_HOME/xmlparserv2.jar:$NLSRTL_HOME/orai18n-collation.jarjava -cp $CLASS_PATH oracle.xquery.XQLPlus $* |
Friday, 14 March 2014
Run XQuery with XqlPlus
I started today with setting up an OSB training and figuring out how to run XQuery scripts outside of OSB. I looked into the (ok a little dated) book: Oracle Database 10g XML&SQL, that I have in my library. In that book there's also a chapter about XQuery.
And it shows that the Oracle XDK has a XQuery processer, but also a commandline tool like SQLPLus: XQLPlus.
It is in the xquery jar, but how to run it? Well you need at least the xquery.jar, but the xmlparserv2.jar is handy for more specialized functions. For localization functionality the orai18n-collation.jar is recommended. In this blog I found some of the basic jar files to put in the classpath.
To put things together in a convenient start script I created the following bash script:
Maybe it can come handy for others as well.
Subscribe to:
Post Comments
(
Atom
)
No comments :
Post a Comment