Can someone please give me an example of a calling a pl/sql procedure from a struts action that includes out parameters. Sandra gave me the following code to create in my ViewRowImpl class
public void callMyProcedure()
throws Exception
{
Bc4jDBTransaction dbTransaction = (Bc4jDBTransaction)(get[Entity]().getDBTransaction());
String statement =
"begin my_procedure([arguments]); end;";
CallableStatement cs = dbTransaction.createCallableStatement(statement,0);
cs.execute();
cs.close();
}
but I need to use out parameters and the documentation on Callable Statement doesnt have any examples ? I see I have to regsiter the out params first ?? Help ?? Also to call from my struts action - I define an interface that is implemented by my ViewRowImpl class (correct ?) but then how do I call this from my struts action ?
ViewRowInterface proc = proc.callMyProcedure(arg1,arg2) ??
Thanks,
Brent