Insbridge Treats A Variable With A Value Of Zero And NULL As The Same
Last updated on APRIL 27, 2018
Applies to:Oracle Insurance Insbridge Rating and Underwriting - Version 18.104.22.168.0 and later
Information in this document applies to any platform.
Insbridge handles NULL values in numeric-type Result Variables (integers, decimals). Insbridge casts all NULL values to zeros, which works in calculations. However, Insbridge also does this casting in IF-condition statements. So, Insbridge treats a variable with a value of zero and NULL as the same thing. We can’t check for NULL values, even when 0 is a valid value we would like to use. How do we differentiate between NULLS and zeros?
Sign In with your My Oracle Support account
Don't have a My Oracle Support account? Click to get started
My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms