Stored Procedures
Stored procedures are function-like interfaces that extend the functionality of the adapter beyond simple SELECT/INSERT/UPDATE/DELETE operations with .
Stored procedures accept a list of parameters, perform their intended function, and then return any relevant response data from , along with an indication of whether the procedure succeeded or failed.
Adapter Stored Procedures
| Name | Description |
| CreateIncidentResponse | Creates an incident along with a thread entry and sends a response. |
| CreateSchema | Creates a schema definition of a table in Oracle Service Cloud. |
| DeleteFileAttachment | Delete a file attachment of a specific instance of a resource. |
| DownloadAllFileAttachmentsOfAResource | Download all file attachments of a specific instance of a resource. |
| DownloadBase64FileAttachment | Download Base-64 encoded file attachment of a specific instance of a resource. |
| DownloadIndividualFileAttachment | Download a file attachment of a specific instance of a resource. |
| ResetPasswordForContact | Reset a password for contact. |
| RunMarketingCampaigns | Start a marketing campaign or flow by providing an entry point. |
| SendMailingToContact | Sends a transactional mailing or survey to a contact at a scheduled time. |
| UpdateIncidentResponse | Updates an incident along with a thread entry and sends a response. |
| UpdateIncidentThread | Updates a thread of an incident object |
| UploadAttachment | Upload a file attachment of a specific instance of a resource. |