Params and property isNull

[dpsistemi]

Hi !

I'm now using ODAC 5.50.15 in D5.
Recently i upgrade the version of ODAC from 2.50 to 5.50

Well, i have a Oracle Function that return a Varchar2, with in some case the result := Null

With ODAC 2.50, the test Params[0].isNull work correctly
With ODAC 5.50, this test fails

Thanks

[Alex]

Send us please small demo project to demonstrate the problem and include script to create server objects to ODAC support address.

[dpsistemi]

For the problem of Property Params.isNull

Code: Select all

-- Oracle Function
FUNCTION FC_PIPPO RETURN VARCHAR2
AS
BEGIN
  RETURN(NULL);
END;

-- Delphi DFM
  object OraStoredProc1: TOraStoredProc
    StoredProcName = 'FC_PIPPO'
    Session = OraSession1
    SQL.Strings = (
      'begin'
      '  :RESULT := FC_PIPPO;'
      'end;')
    Left = 100
    Top = 48
    ParamData = 
  end

-- Delphi pas
OraStoredProc1.Execute ;
if OraStoredProc1.Params[0].isNull then ShowMessage('null')
                                   else ShowMessage('not null') ;

In execution, the output message is 'NOT NULL', but the value assigned by oracle is NULL

Thanks

[Alex]

Thank you for information.
We reproduced your problem and fixed it. This fix will be included in the next ODAC build.

[wsUser]

I'm still getting the error described by dpsistemi
with:

ODAC 5.80.0.36
Delphi 7
Oracle 10g

Isn't this already fixed?

Thanks