Notice: this Wiki will be going read only early in 2024 and edits will no longer be possible. Please see: https://gitlab.eclipse.org/eclipsefdn/helpdesk/-/wikis/Wiki-shutdown-plan for the plan.
EclipseLink/Examples/JPA/nonJDBCArgsToStoredProcedures
< EclipseLink | Examples | JPA
Revision as of 12:30, 23 November 2007 by Michael.norman.oracle.com (Talk | contribs) (→How to handle nonJDBC arguments for Oracle Stored Procedures)
{available as of EclipseLink 1.0M2}
How to handle nonJDBC arguments for Oracle Stored Procedures
The standard way of handling a Stored Procedure is to build an instance of oracle.toplink.queryframework.StoredProcedureCall. However, the arguments must be compatible with the JDBC specification.
To handle nonJDBC arguments (e.g. BOOLEAN, PLS_INTEGER, PL/SQL record, etc.) a new sub-class has been created: oracle.toplink.platform.database.oracle.PLSQLStoredProcedureCall:
For a target procedure:
<span style='color:#575757; font-weight:bold; '>procedure</span> bool_test<span style='color:#555555; '>(</span>x <span style='color:#575757; font-weight:bold; '>IN</span> <span style='color:#575757; font-weight:bold; '>BOOLEAN</span><span style='color:#555555; '>)</span>
x