Generic Oracle DB Mngr

[bentalcy]

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]

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);
}

JDBC supports stored procedures via the CallableStatement interface.
Oracle provides a JDBC driver.

HTH,
Ray