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 (Webobjects-dev@lists.apple.com)
Help/Unsubscribe/Update your Subscription:
http://lists.apple.com/mailman/options/webobjects-dev/archive%40mail-archive.com
This email sent to arch...@mail-archive.com
