This week's book giveaway is in the Agile and Other Processes forum.
We're giving away four copies of The Little Book of Impediments (e-book only) and have Tom Perry on-line!
See this thread for details.
Win a copy of The Little Book of Impediments (e-book only) this week in the Agile and Other Processes forum!
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

Related to calling stored procedure

 
Jignesh Gohel
Ranch Hand
Posts: 276
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Hello ,

Please help me understand the below technique of calling the Stored Procedure written in Oracle using java.In our application it is working fine but while surfing i found out that some people got exceptions using this technique and some of the experts recommended using the technique of
{call ... }

connection.prepareCall("begin XYZProc(?,?,?,?); end;");

Thanks in advance.
 
Jeanne Boyarsky
author & internet detective
Marshal
Posts: 35279
384
Eclipse IDE Java VI Editor
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Jignesh,
Some database drivers are more flexible than others. This accounts for many problems you hear about on the Internet.
 
Jignesh Gohel
Ranch Hand
Posts: 276
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Thanks Jeanne for the reply.

But,I didn't get your point clearly.
Also can you please elborate on how the below thing works ??

connection.prepareCall("begin XYZProc(?,?,?,?); end;");
[ December 19, 2006: Message edited by: Jignesh Gohel ]
 
With a little knowledge, a cast iron skillet is non-stick and lasts a lifetime.
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic