| 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
internet detective
Marshal
Joined: May 26, 2003
Posts: 26193
|
|
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 ]
|
|
 |
|
|
subject: Related to calling stored procedure
|
|
|
0
