Upgraded from 6.90 to 9.0 Wrong number of types...

[valentl]

Hello,

Last week our company tried to updage from ODAC 6.90 to ODAC 9, (Delphi 2007) which did not succeded. We are using ODAC for a very long time, and these very old stored functions does not have the isresult=true property in the component.
For example, I have created this simple function:

Code: Select all

create or replace function proba_uj_Tranzakcio return float is
begin
  return 0;
end;

And the Delphi Component:

Code: Select all

  object stp_proba: TOraStoredProc
    StoredProcName = 'proba_uj_tranzakcio'
    Session = OraSession1
    SQL.Strings = (
      'begin'
      '  :RESULT := proba_uj_tranzakcio;'
      'end;')
    Options.AutoPrepare = True
    Left = 96
    Top = 164
    ParamData = <
      item
        DataType = ftFloat
        Name = 'RESULT'
        ParamType = ptOutput
      end>
  end

Clearly visible, that the

CommandStoredProcname, isResult

properties does not exists in the component, but it works with ODAC 6.90
However, with ODAC 9, it gives a worng number or types... error message, because ODAC 9 tries to call

Code: Select all

tranzakcio( :RESULT);

, instead of

Code: Select all

:RESULT := proba_uj_tranzakcio;

One thing, that may help. If the Commandstoredprocname property exists, but the isResult doesn't, it will not work on ODAC 6.90, but we have never had problem with this. Only these very old stored functions (for example one of them was created in 1998) are causing problems with ODAC 9. Maybe the ODAC version 2 in 2001 (the first ODAC version we were using with Delphi3) did not had these properties?

[AlexP]

Hello,

We know about the problem with IsResult in dfm and will try to fix this behaviour in the next build.

[valentl]

Thank you for the quick answer