Home » Developer & Programmer » JDeveloper, Java & XML » PreparedStatement In Table Partition - Select * From Table Partition (?)
icon4.gif  PreparedStatement In Table Partition - Select * From Table Partition (?) [message #197501] Wed, 11 October 2006 08:50
felipevinturini
Messages: 10
Registered: August 2005
Location: Brazil
Junior Member

Hi All,

I am trying to use the question mark in the PrepartedStatement for the name of a table partition, like the following:
===============================================================
prepStmt = dbConnection.prepareStatement("Select Ano From Ia_Trans_Upd Partition ( ? ) Where Ano = ? ");
prepStmt.setString(1, "P_IATRNSU_20060731");
prepStmt.setString(2, "5381249150");
===============================================================

But I am facing the following error:
===============================================================
java.sql.SQLException: ORA-00933: SQL command not properly ended
===============================================================

When I put in the query the table partition name, instead of using the question mark, it works ok.

Is it possible to do this(so Am I doing something wrong?) or I can use the question mark only in the Where clause?

Thanks for your assistance.

[Updated on: Wed, 11 October 2006 08:51]

Report message to a moderator

Previous Topic: Java Stored Procedures take longer to execute
Next Topic: XSL Transformation in Oracle 9i
Goto Forum:
  


Current Time: Tue Dec 06 12:35:50 CST 2016

Total time taken to generate the page: 0.05489 seconds