Below is an example Procedure that invokes the Web API call "/services/webservices/system/admin/resource/operations/getDependentResources", that makes use of a variable passed into the procedure and includes the 'resource' variable in the procedure call.
===========
PROCEDURE proc1(OUT response XML, IN resource VARCHAR)
BEGIN
DECLARE fault XML;
-- Declare xml_payload as an XML data type
DECLARE xml_payload XML;
-- Create the XML payload piece by piece
SET xml_payload = '<resource:getUsedDataSources xmlns:resource="http://www.compositesw.com/services/system/admin/resource" xmlns:common="http://www.compositesw.com/services/system/util/common">' ||
'<resource:entries>' ||
'<resource:entry>' ||
'<resource:path>/shared/examples/ds_orders/tutorial/' || resource || '</resource:path>' ||
'<resource:type>TABLE</resource:type>' ||
'</resource:entry>' ||
'</resource:entries>' ||
'<resource:detail>SIMPLE</resource:detail>' ||
'</resource:getUsedDataSources>';
-- Make the CALL statement using the constructed XML payload
CALL /services/webservices/system/admin/resource/operations/getUsedDataSources (xml_payload, response, fault);
END
=======
When invoking the procedure, it is essential to furnish a value for the resource parameter. This value must be a string that signifies the resource you intend to include in the XML payload. The input value for the resource parameter will determine the resource name or value to be utilized in your XML payload when invoking the procedure.