Posted: Thu Apr 26, 2007 4:39 am Post subject: Getting SQL Error while trying to call a Stored Proc
Apprentice
Joined: 03 Jul 2003 Posts: 25 Location: Kolkata
I am using WPS test server v6.0.2. I have created a BO with the Enterprise Service discovery using for a stored procedure in Oracle 10g R2. The Stored Procedure is a simple one having a input parameter and a output parameter. However, when testing the Stored Procedure in a WPS Test Server, it is always throwing the exception "java.sql.SQLException: Missing IN or OUT parameter at index:: 1".
However, the exact stored procedure runs smoothly when DB2 v8.2 is used.
Any help or suggestion to recover the exception..............!!!!
The Oracle JDBC driver lib (classes12.jar/classes12.zip) both seems to be working fine because I am able to perform normal DML operations in the database with the adapter.
You cannot post new topics in this forum You cannot reply to topics in this forum You cannot edit your posts in this forum You cannot delete your posts in this forum You cannot vote in polls in this forum