Devart Forums

Posted: **Fri 07 Oct 2005 08:37**

If you use TOraPackage with a procedure have multiple signatur in DataBase, TOraPackage found always the first!!!

Sample,
Create procedure

Code: Select all

  function CheckIn(Id IN ltm_entity_log.elo_rec_id%TYPE,
    SysLogType IN ltm_entity_log.c_ltm_sys_log%TYPE)
    return PLS_INTEGER;
  function CheckIn(Id IN ltm_entity_log.elo_rec_id%TYPE,
    SysLogType IN ltm_entity_log.c_ltm_sys_log%TYPE,
    Commentary IN ltm_entity_log.elo_info%TYPE)
    return PLS_INTEGER;
  function CheckIn(Id IN ltm_entity_log.elo_rec_id%TYPE,
    SysLogType IN ltm_entity_log.c_ltm_sys_log%TYPE,
    Commentary IN ltm_entity_log.elo_info%TYPE,
    Author IN ltm_entity_log.elo_author%TYPE)
    return PLS_INTEGER;

And use TOraPackage

Code: Select all

     nRes := foraPackage.ExecProcEx('CheckIn',
        ['Id', MainId, 'SysLogType', SysLogType, 'Commentary', strComment,
         'Author', UserInitials]) as Integer;

The params list contains ID and SYSLOGTYPE, parameters for the first procedure.

And ExecProcEx generate an exception Commentary was not found.

NSC

Posted: **Fri 07 Oct 2005 13:06**

Thanks for assistance.
We will add an overloaded routine call functionality in OraPackage and OraSession in the next ODAC build.

Devart Forums

TOraPackage with multiple Procedure

TOraPackage with multiple Procedure