File APIs for Java Developers
Manipulate DOC, XLS, PPT, PDF and many others from your application.
http://aspose.com/file-tools
The moose likes JDBC and Relational Databases and the fly likes Optionally Setting parameters for Oracle functions from jdbc Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login


Win a copy of OCA Java SE 8 Programmer I Study Guide 1Z0-808 this week in the OCAJP forum!
JavaRanch » Java Forums » Databases » JDBC and Relational Databases
Bookmark "Optionally Setting parameters for Oracle functions from jdbc" Watch "Optionally Setting parameters for Oracle functions from jdbc" New topic
Author

Optionally Setting parameters for Oracle functions from jdbc

Ann Sebastian
Ranch Hand

Joined: Sep 21, 2005
Posts: 37


I want to ?optionally set the parameter,Sometimes voucherTbId wont have values,So line 1 will be skipped due to if condition

In that case,stmt.execute throws an error.Is there any way to do it???
 
It is sorta covered in the JavaRanch Style Guide.
 
subject: Optionally Setting parameters for Oracle functions from jdbc