Page 1 of 1
Params and property isNull
Posted: Thu 03 Mar 2005 09:46
by 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
Posted: Thu 03 Mar 2005 14:19
by Alex
Send us please small demo project to demonstrate the problem and include script to create server objects to ODAC support address.
Source Example
Posted: Fri 04 Mar 2005 08:39
by 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
Posted: Sat 05 Mar 2005 09:29
by Alex
Thank you for information.
We reproduced your problem and fixed it. This fix will be included in the next ODAC build.
Posted: Wed 30 May 2007 15:17
by 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