Re: EOF Oracle function call

Subject: Re: EOF Oracle function call
From: Tom Pelaia <email@hidden>
Date: Thu, 22 Jan 2009 10:20:43 -0500

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@hidden)
Help/Unsubscribe/Update your Subscription:

This email sent to email@hidden

Prev by Date: Re: [OT] ActiveRecord.js
Next by Date: Re: Behaviour of objectsWithFetchSpecification()
Previous by thread: Re: how to setval from migrations????
Next by thread: plist to xml conversion of lists
Index(es):
- Date
- Thread