Symptoms
This occurs after setting "Complex output as XML" to false in the Oracle service instance.
Diagnoses
Issue is due to the service broker being unable to handle null input values for store procedures
Resolution
The workaround is to add a null check on the input value in the stored procedure. For example:
if (input_xml != null) THEN
input_xml3 := xmltype(input_xml)
END IF
