Mailing Lists: Apple Mailing Lists
 Image of Mac OS face in stamp
Oracle Function call
[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

Oracle Function call

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

This email sent to email@hidden


Visit the Apple Store online or at retail locations.
1-800-MY-APPLE

Contact Apple | Terms of Use | Privacy Policy

Copyright © 2011 Apple Inc. All rights reserved.