No ratings

Oracle stored procedure smartobject shows method as "List(Invalid)"




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





Version history
Last update:
‎05-30-2016 09:16 PM
Updated by:
Contributors