Meaningless Drivel is fun!*
The moose likes JDBC 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 Murach's Java Servlets and JSP this week in the Servlets forum!
JavaRanch » Java Forums » Databases » JDBC
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???
 
Consider Paul's rocket mass heater.
 
subject: Optionally Setting parameters for Oracle functions from jdbc
 
Similar Threads
Stored procedure which returns array
Set Method for Oracle Database
help regarding jdbc
JDBC input parameter for type IS TABLE OF VARCHAR2
Line Counting in Java