• Post Reply Bookmark Topic Watch Topic
  • New Topic

urgent help-on accessing Stored procedures  RSS feed

 
Jack Nicholson
Ranch Hand
Posts: 41
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Hello ,
I am using statless bean for accessing oracle d/b.
Here i want to access the d/b stored procedures for faster data inputs.
but i don't know how to access it.
can anybody tell me about that.
I just know i have to use CallableStatement. but don't know how to provide parameters for that procedure which returns none. but after calling it
just gives 0/1 for not-executed/ executeed procedure.
& also if suppose if i want to access procedure which returns value, how to grab it?
Thanx in advance
 
Detlef Winkelvoss
Greenhorn
Posts: 2
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Hi Jack,
the best way to study oracle examples is to read the JDBC Developers Guide available on http://technet.oracle.com
There are many samples to call procedures.
I had problems to call object types in procedures.
In the meantime I have some experience with this.
When You have further questions you can write me for an example.
wbr. winkel
 
  • Post Reply Bookmark Topic Watch Topic
  • New Topic
Boost this thread!