File APIs for Java Developers
Manipulate DOC, XLS, PPT, PDF and many others from your application.
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
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: 33124

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]
Other Certs: SCEA Part 1, Part 2 & 3, Core Spring 3, 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
It's not a secret anymore!