TOraclePackage with returning null string

[Ken Leach]

When I call a integer function in a package and it returns null string for one of it OUT params.. I need to know how to test is for being null... I get an "invalid variant operation now.. how can I test for this?

lvi_current_count:=DOASP_filter.CallIntegerFunction('VALIDATE_FILTER_ITEMS',
['pvi_filtertype_key',cao_params[pn_filter_type].rvi_key,
'pvs_values',pvs_string,
'pvi_retailer',cao_params[pn_retailer].rvi_key,
'pvi_vendor',cao_params[pn_vendor].rvi_key,
'pvs_validreturn',parString,
'pvs_invalidreturn',parString]);
lvi_count:=lvi_count+lvi_current_count;

//HERE!!!!
if DOASP_filter.getparameter('pvs_invalidreturn') null then
// if not null add it to a string.... ?? HOW??? lvs_invalid:=lvs_invalid+DOASP_filter.getparameter('pvs_invalidreturn');
if DOASP_filter.getparameter('pvs_validreturn') null then
lvs_valid:=lvs_valid+DOASP_filter.getparameter('pvs_validreturn');

 

[Marco Kalter]

If TOracleSession.NullValue = nvUnassigned, null values will be returned as Unassigned variant values. You can't compare Unassigned variants, this will lead to an exception. To check for unassigned variant values, use VarIsEmpty(value).

------------------
Marco Kalter
Allround Automations