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

Z
Badge +9


 

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




 

0 replies

Be the first to reply!

Reply


View our Community Site Map

Nintex Community Sitemap
Terms & ConditionsCookie settings