Calling Procedure() from java
Posted by:
Anil Patimalla ()
Date: October 23, 2009 10:25AM
While I am Executing a Procedure from java,Its Type of String Containing Procedure
This is My Coding Part :
CallableStatement callStmt = con.prepareCall(eQuery);
boolean proc1 = callStmt.execute();
callStmt.close(); callStmt = null;
callStmt = con.prepareCall("{call AnonymousProc()}");
boolean proc = callStmt.execute();
In the First Call the Procedure Gets Executed And for the Second call The Procedures Fires.and Does the Some Operations.
The Problem is When i am Using this Code in Stand Alone its Working fine.But If i Make use of the same in an Package Application .The Procedure Call in not Working.
stating that particular Procedure doesnt exisit.In my Application I have to Execute Number of Sql Files with Procedures.
if any one get me out of this ,
Thanks in Advance
Sorry, only registered users may post in this forum.
© 1995-2008 MySQL AB, 2008- Sun Microsystems, Inc.