Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

STORED PROCEDURES JDBC

Status
Not open for further replies.
sweetsgup

sweetsgup

Programmer
Joined
Oct 22, 2000
Messages
6
Location
MY
Hi I desperately need some help regarding the following.

I am trying to read a list of stored procedure names and their input parameters from a file and execuet them one after the other irrespective of any errors.

I would like to know if i could put this statement in a loop till EOF:

CallableStatement cstnt = con.prepareCall
("{call stprocname(24, 56)}");

Instead of setting the parameters seperately?

would appreciate some help on this. thanks in advance.


 
Status
Not open for further replies.

Similar threads

TariqMehmod
  • Locked
  • Question Question
Which JDBC Driver
Replies
1
Views
733
xwb
xwb
MartinF
  • Locked
  • Question Question
JDBC SQLServer 2000 connection problem
Replies
3
Views
496
TonHu
TonHu
chunkII123
  • Locked
  • Question Question
How to keep MySQL connection alive via JDBC Driver
Replies
4
Views
729
Diancecht
Diancecht
Toe
  • Locked
  • Question Question
JDBC connection problems
Replies
6
Views
525
Canelas
Canelas
pen81
  • Locked
  • Question Question
Connecting to MS SQL via JDBC
Replies
3
Views
401
Diancecht
Diancecht

Part and Inventory Search

Sponsor

Back
Top