Win a copy of Functional Reactive Programming this week in the Other Languages forum!
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

Calling stored procedures from Java

 
Sirisha Reddy
Ranch Hand
Posts: 75
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Is there a way to call a stored procedure and other PL/SQL block that reside in Oracle server, from a java program.
Thanks.
 
Pavel Halas
Ranch Hand
Posts: 35
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Yes. The way is simple. You'll create new statement with something like "begin procedureName() end;".
 
Pavel Halas
Ranch Hand
Posts: 35
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
You'll better follow this...
Java JDBC tutorial
This is warranted.
 
Sujatha Ranganathan
Greenhorn
Posts: 12
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
You will find lot of sample code that demonstrate invoking stored procedures from JDBC here
 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic