*
The moose likes JDBC and the fly likes Cursors in a procedure Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login
JavaRanch » Java Forums » Databases » JDBC
Bookmark "Cursors in a procedure" Watch "Cursors in a procedure" New topic
Author

Cursors in a procedure

Gireesh Mulage
Ranch Hand

Joined: Mar 08, 2010
Posts: 44
HI All,

In the DB procedure , how do I can call 2 different cursors depending on one condition ?

The condition can be any string like 'abc' or 'bcd'......

Thanks
Gireesh Mulage
Paul Sturrock
Bartender

Joined: Apr 14, 2004
Posts: 10336

Use an if statement?


JavaRanch FAQ HowToAskQuestionsOnJavaRanch
Gireesh Mulage
Ranch Hand

Joined: Mar 08, 2010
Posts: 44
Thanks Paul . I got it .
 
jQuery in Action, 2nd edition
 
subject: Cursors in a procedure
 
Similar Threads
Question about cursor as stored procedure parameter
how to develop reports from a stored procedures
SQLException Cursor Closed
CallableStatement (Oracle JDBC)
how to return ref cursor arrays from stored procedure?