I havn’t called Oracle DB from my model but I’ve done it with
java.sql.CallableStatement by passing in all the parameters( including
object to get the output parameters ).
Something like this should get you on track:
/* Dummy code for Oracle function call starting */
Connection conn = DriverManager.getConnection( url, username, password );
conn.setAutoCommit( true );
// the name of your function and parameters with the out parameter of the
function at the start
String procedure = “{?=call STRING_VALUE_FOR_INT( ? ) }”;
CallableStatement c = conn.prepareCall( procedure );
// returning value from the function call
String resultString = null;
c.setString( 1, resultString );
c.registerOutParameter( 1, java.sql.Types.VARCHAR );
// the parameter
c.setInt( 1, 2008 );
c.executeQuery();
ResultString = c.getString( 1 ); c.close();
/* Dummy code for Oracle function call ending */
Þann 1/21/09 8:51 PM, skrfaði "Tom Pelaia" <[email protected]> eftirfarandi:
> Hi,
>
> I am trying to call a function with a return value defined in an Oracle
> database. I found legacy EOF notes indicating that it was possible to do so by
> adding an argument named "returnValue" to the EO stored procedure, but this
> results in the following exception:
> [exec] PLS-00306: wrong number or types of arguments in call to
> 'LOGBOOK_ENTRY_WORK_ORDER_ASSOC'
>
> Has anyone been able to call function on an Oracle database? If so, how?
>
> I've defined my stored procedure in the model as:
> {
> arguments = (
> {
> allowsNull = Y;
> columnName = "p_log_entry_id";
> externalType = NUMBER;
> name = "entryID";
> parameterDirection = 1;
> valueClassName = NSNumber;
> valueType = i;
> },
> {
> allowsNull = Y;
> columnName = "p_work_order_number";
> externalType = NUMBER;
> name = "workOrderID";
> parameterDirection = 1;
> valueClassName = NSNumber;
> valueType = i;
> },
> {
> name = "returnValue";
> parameterDirection = 2;
> externalType = NUMBER;
> parameterDirection = 2;
> valueClassName = NSNumber;
> valueType = i;
> }
> );
> externalName = "logbook.logbook_pkg.logbook_entry_work_order_assoc";
> name = linkToWorkOrder;
> }
>
>
> best regards,
> tom
>
>
> _______________________________________________
> Do not post admin requests to the list. They will be ignored.
> Webobjects-dev mailing list ([email protected])
> Help/Unsubscribe/Update your Subscription:
> http://lists.apple.com/mailman/options/webobjects-dev/logi%40us.is
>
> This email sent to [email protected]
>
>
> Með vegsemd og virðingu,
> Logi Helgu
Fyrirvari á tölvupósti / e-mail disclaimer
http://us.is/Apps/WebObjects/US.woa/wa/dp?id=3776
_______________________________________________
Do not post admin requests to the list. They will be ignored.
Webobjects-dev mailing list ([email protected])
Help/Unsubscribe/Update your Subscription:
http://lists.apple.com/mailman/options/webobjects-dev/archive%40mail-archive.com
This email sent to [email protected]
