SQLException

[Kartik Ruppa]

hi,
am not sure whether this is the right place for this query.Pls do help me out if possible.
i get the follwing error message when trying to remove rows from oracle db.
java.sql.SQLException: Missing IN- or OUT-parameter i index:: 1
Am using oracle 8.1.7 ,CMP beans and Websphere for my application.
my code snippet is as follows:
for(Enumeration trmenum = trolemodulehome.findTrolemoduleByMrole(mrolekey); trmenum.hasMoreElements(); test.remove())
{
test = (Trolemodule)PortableRemoteObject.narrow(trmenum.nextElement(),com.arena.security.Trolemodule.class);

}
what mistake am i doing.pls help me out.
thanks
kabs

[Mark Spritzler]

Not sure, but I think your duplicate post in IBM Websphere should be a better place to get an answer.
From my guess It doesn't look like an Oracle error per say.
My guess is that your EJB code is calling a Stored Procedure, but not including the parameters in the call.
I am closing this thread so that you don't have duplicate posts.
Mark