updateExternalSqlProcedure
Update the definition of an External SQL procedure (packaged query) resource. If the procedure is updated with a path to a data source that does not exist, the resource becomes impacted, and it does not execute until this is corrected.
Location
/services/webservices/system/admin/resource/operations/
Request Elements
path: A fully qualified path to the resource.
detail: The level of detail about the resources to include in the response. Valid values are NONE, SIMPLE, and FULL.
externalSqlText: The native SQL source text.
externalDataSourcePath (optional): A path to the data source in which to run the native SQL. If not provided, the data source is left unaltered.
parameters (optional): List of parameter definitions for this procedure. If not provided, the parameters are left unaltered. See
Parameters Element.
• annotation (optional): A description of this parameter.
annotation (optional): A description of the resource. If not provided, the annotation is left unaltered.
attributes (optional): Resource-specific attributes. Sets the specified attributes but does not alter the values of unspecified attributes. See
Attributes Element.
Response Elements
resources: List of the updated resources. See
Resources Element.
Faults
IllegalArgument: Either one of the given paths is malformed, or the detail is invalid.
NotFound: If the resource does not exist.
Security: If the user does not have READ access on all items in path other than the last one.
Security: If the user does not have WRITE access to the last item in path.
Security: If the user does not have the ACCESS_TOOLS right.