Java Database Connectivity (JDBC)

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!

sqlbase - how to run a stored procedure with SYSDATE argument

843859Mar 25 2008 — edited Mar 26 2008

Hi, everyone!

I'm trying to execute a stored procedure :

cstmt = con.prepareCall("{ call PR_MYPROCEDURE(?, SYSDATE-1, SYSDATE) }");
cstmt.setInt(1,1);

And i get and SqlException - java.sql.SQLException: prepareCall(): An unexpected character 'S' found.
Is there any way to pass a SYSDATE like argument?

Locked Post

New comments cannot be posted to this locked post.

Locked on Apr 23 2008

Added on Mar 25 2008

#java-database-connectivity-jdbc

4 comments

430 views