ストアドプロシージャ

ストアドプロシージャはファンクションライクなインターフェースで、Oracle Service Cloud の単純なSELECT/INSERT/UPDATE/DELETE 処理にとどまらず本製品の機能を拡張します。

ストアドプロシージャは、パラメータのリストを受け取り、目的の機能を実行し、プロシージャが成功したか失敗したかを示すとともにOracle Service Cloud から関連するレスポンスデータを返します。

CData SSIS Components for Oracle Service Cloud ストアドプロシージャ


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.