aspose file tools*
The moose likes JDBC 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
Bookmark "Related to calling stored procedure" Watch "Related to calling stored procedure" New topic
Author

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.


Regards,
Jignesh

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

Joined: May 26, 2003
Posts: 30929
    
158

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


[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: http://aspose.com/file-tools
 
subject: Related to calling stored procedure