Stored Procedures
Stored procedures are function-like interfaces that extend the functionality of the component beyond simple SELECT/INSERT/UPDATE/DELETE operations with Oracle Service Cloud.
Stored procedures accept a list of parameters, perform their intended function, and then return any relevant response data from Oracle Service Cloud, along with an indication of whether the procedure succeeded or failed.
CData SSIS Components for Oracle Service Cloud 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. |