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.
|
|
|