Hi,
Thanks to all who replied. I figured out how to configure the EO
Attribute to make an Oracle function call (like a stored procedure
with a return value). The key document that explains how to do it is: http://support.apple.com/kb/TA46172?viewlocale=en_US
Basically, you need to treat an Oracle Function as a stored procedure
with an out parameter. You must set the column name to "000" (three
zeros), the name of the attribute to "returnValue" and the parameter
direction to "2". Set the external and internal types as expected.
Here is the stored procedure definition that worked (note the last
argument):
{
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";
columnName = "000";
parameterDirection = 2;
externalType = NUMBER;
valueClassName = NSNumber;
valueType = i;
}
);
externalName =
"logbook.logbook_pkg.logbook_entry_work_order_assoc";
name = linkToWorkOrder;
}
thanks,
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/archive%40mail-archive.com
This email sent to [email protected]
