Ali,
Have a search around - lots of examples on the forum.
Something like this works:
DBTransaction trans = getDBTransaction();
PreparedStatement stmt = trans.createPreparedStatement("begin mypackage.myproc(:1, :2); end;", 0);
try
{
stmt.setInt(1, inputSheetID);
stmt.setInt(2, planYear);
stmt.execute();
}
As code in the app module's implementation. You can then expose the method to the client and either call it directly or use the binding layer.
John
