aspose file tools
The moose likes JDBC and Relational Databases and the fly likes Related to calling stored procedure Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login

Win a copy of Groovy Fundamentals video training course this week in the Groovy forum!
JavaRanch » Java Forums » Databases » JDBC and Relational Databases
Bookmark "Related to calling stored procedure" Watch "Related to calling stored procedure" New topic

Related to calling stored procedure

Jignesh Gohel
Ranch Hand

Joined: Dec 28, 2004
Posts: 276
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.


The Art Of Life Is To Know When To Be Useless And When To Be Useful - CHUANG TZU
Jeanne Boyarsky
author & internet detective

Joined: May 26, 2003
Posts: 32077

Some database drivers are more flexible than others. This accounts for many problems you hear about on the Internet.

[OCA 8 book] [Blog] [JavaRanch FAQ] [How To Ask Questions The Smart Way] [Book Promos]
Blogging on Certs: SCEA Part 1, Part 2 & 3, Core Spring 3, OCAJP, OCPJP beta, TOGAF part 1 and part 2
Jignesh Gohel
Ranch Hand

Joined: Dec 28, 2004
Posts: 276
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 ]
I agree. Here's the link:
subject: Related to calling stored procedure