Skip to Main Content
Forums

DevOps, CI/CD and Automation

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Interested in getting your voice heard by members of the Developer Marketing team at Oracle? Check out this post for AppDev or this post for AI focus group information.

XSU doesn't support bind variables - how dumb is that?

steve.westJul 4 2007
I am using XSU to generate XML from a SQL statement using class OracleXMLQuery. Either I am blind or stupid or there is no support for bind variables in this class! I have used DBMS_xmlquery in PL/SQL before and this does support bind variables, I naturally assumed the Java equivalent would also have this. The lack of bind variable support means a huge performance hit as every single SQL statement will be treated as unique and will require hard parsing on the server!

Is there another Java XML utility I can use for generating XML from a SQL statement that does support bind variables? I have trawled through the Oracle documentation and I am getting very confused and lost.


Thanks,

Steve

Comments

Srinath Menon-Oracle 
Refer Oracle Database Administrator's Guide to install XA transaction recovery views\synonyms
  using the script xaview.sql. Contact your DBA.

You will need to navigate to the following location and run the xaview.sql script :

With version 12, you will need to enable XA transactions via the xaview.sql script (in the PDB container if using a PDB database)

cd $ORACLE_HOME/javavm/install

sqlplus sys/password@SID as sysdba @initxa.sql    (if this exists in your version of the DB)

cd $ORACLE_HOME/rdbms/admin

sqlplus sys/password@SID as sysdba @xaview.sql

Note that the SID above is for the container, if your DB uses that.
1 person found this helpful
1 - 1
Locked Post
New comments cannot be posted to this locked post.

Post Details

Locked on Aug 1 2007
Added on Jul 4 2007
#general-xml, #xml
0 comments
1,349 views