ストアドプロシージャ
ストアドプロシージャはファンクションライクなインターフェースで、Oracle Sales の単純なSELECT/INSERT/UPDATE/DELETE 処理にとどまらず本製品 の機能を拡張します。
ストアドプロシージャは、パラメータのリストを受け取り、目的の機能を実行し、プロシージャが成功したか失敗したかを示すとともにOracle Sales から関連するレスポンスデータを返します。
CData SSIS Components for Oracle Sales ストアドプロシージャ
| Name | Description |
| CreateSchema | Creates a schema file for the specified table or view. |
| DeleteAccountsAttachment | Delete an attachment. |
| DeleteActivityAttachment | Delete an attachment. |
| DeleteContactsAttachment | Delete an attachment. |
| DeleteContactsPictureAttachment | Delete an attachment. |
| DeleteOpportunityAttachment | Delete an attachment. |
| DeleteSalesLeadsAttachment | Delete an attachment. |
| UpdateAccountsAttachment | Update an attachment. |
| UpdateActivityAttachment | Update an attachment. |
| UpdateContactPictureAttachment | Update an attachment. |
| UpdateContactsAttachment | Update an attachment. |
| UpdateOpportunityAttachment | Update an attachment. |
| UpdateSalesLeadsAttachment | Update an attachment. |
| UploadAccountsAttachment | Upload an attachment. |
| UploadActivityAttachment | Upload an attachment. |
| UploadContactAttachment | Upload an attachment. |
| UploadContactPictureAttachment | Upload a picture attachment. |
| UploadOpportunityAttachment | Upload an attachment. |
| UploadSalesLeadsAttachment | Upload an attachment. |