My Oracle Support Banner

Insbridge Treats A Variable With A Value Of Zero And NULL As The Same (Doc ID 2392216.1)

Last updated on SEPTEMBER 18, 2019

Applies to:

Oracle Insurance Insbridge Rating and Underwriting - Version 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?


To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!

In this Document

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.