Home » Developer & Programmer » JDeveloper, Java & XML » JDBC 10g XA Drivers and Rank( )
JDBC 10g XA Drivers and Rank( ) [message #177438] Wed, 14 June 2006 10:41
Kavitha Suresh
Messages: 22
Registered: September 2005
Junior Member
We are facing an issue when we try to execute a procedure (callable statement) from Weblogic using JDBC 10g Oracle Drivers (XA Version). The Procedure has a query which uses Rank() over and when that is commented the issue does not arise. Also, with the non-XA version we do not face any issues. I did not come across any restriction/limitations which specifies that we cannot use rank( ) with XA. Below is the information I have

Weblogic Version : 8.1 SP4
Driver : Type 4 JDBC Oracle Thin driver (XA)
Error : java.sql.SQLException: ORA-32036: unsupported case for inlining of query name in WITH clause

Thanks in advance for any information / help to resolve the above issue.

Previous Topic: Read Unicode chars and insert into Oracle DB
Next Topic: Java or C++ with Oracle (for future use)?
Goto Forum:
  


Current Time: Fri Nov 22 05:36:51 CST 2024