Upgraded from 6.90 to 9.0 Wrong number of types...
Posted: Wed 22 May 2013 06:52
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:
And the Delphi Component:
Clearly visible, that the
However, with ODAC 9, it gives a worng number or types... error message, because ODAC 9 tries to call, instead of
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?
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;
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
properties does not exists in the component, but it works with ODAC 6.90CommandStoredProcname, isResult
However, with ODAC 9, it gives a worng number or types... error message, because ODAC 9 tries to call
Code: Select all
tranzakcio( :RESULT);Code: Select all
:RESULT := proba_uj_tranzakcio;