Apple

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

References:
	>Re: Re: last chance for stable (From: Tom Pelaia <email@hidden>)