I am using the following SQL line that pulls and parses XML data from an Oracle database.
xmltype(ssn.serial_lot_number).extract('//Serial/text()').getStringVal() as xml_serial,
xmltype(ssn.serial_lot_number).extract('//Lot/text()').getStringVal() as xml_lot,
I am finding that several database records have NULL in the serial_lot_number field which caused an error with the SQL statement. How do I account for NULL?