Can anyone point me (share code) to a Java wrapper (aka DB-Mngr, aka
data access object) that supports a call to Oracle SPs.
Something that would basicly implement:
Interface DatabaseMgnr
{
//supports select
ResultSet ExecSP(String pKgAndprocName, Collection parameters);
//supports update\insert\delete
void ExecSP(pKgAndprocName, Collection parameters);
}
Raymond DeCampo - 23 Jan 2006 03:36 GMT
> Can anyone point me (share code) to a Java wrapper (aka DB-Mngr, aka
> data access object) that supports a call to Oracle SPs.
[quoted text clipped - 9 lines]
> void ExecSP(pKgAndprocName, Collection parameters);
> }
JDBC supports stored procedures via the CallableStatement interface.
Oracle provides a JDBC driver.
HTH,
Ray

Signature
This signature intentionally left blank.