Hi All,
We are calling our Oracle stored procedure across a database link from a MS SQL database and are getting the following error ...
Error was could not execute native bulk manipulation query:exec AddBookingToCRM @p_attribute1 = 'Other Bulky', @p_attribute2 = '1', @p_attribute3 = 'Not Specified', @p_attribute4 = 'N/A', @p_attribute5 = 'Not Specified', @p_attribute8 = '1231', @p_attribute9 = '91665', @p_customer_title = 'Mr', @p_customer_firstname = 'Scott', @p_customer_surname = 'Burton', @p_customer_uprn = '64004572', @p_customer_area_code = '01234', @p_customer_phone = '567984', @p_customer_email = 'nickmasefield@zipporah.co.uk', @p_contact_title = 'Mr', @p_contact_firstname = 'Scott', @p_contact_surname = 'Burton', @p_contact_area_code = '01234', @p_contact_phone = '567984', @p_contact_email = 'nickmasefield@zipporah.co.uk', @p_resolution_date = '2016-02-11 07:00:00' [SQL: exec AddBookingToCRM @p_attribute1 = 'Other Bulky', @p_attribute2 = '1', @p_attribute3 = 'Not Specified', @p_attribute4 = 'N/A', @p_attribute5 = 'Not Specified', @p_attribute8 = '1231', @p_attribute9 = '91665', @p_customer_title = 'Mr', @p_customer_firstname = 'Scott', @p_customer_surname = 'Burton', @p_customer_uprn = '64004572', @p_customer_area_code = '01234', @p_customer_phone = '567984', @p_customer_email = 'nickmasefield@zipporah.co.uk', @p_contact_title = 'Mr', @p_contact_firstname = 'Scott', @p_contact_surname = 'Burton', @p_contact_area_code = '01234', @p_contact_phone = '567984', @p_contact_email = 'nickmasefield@zipporah.co.uk', @p_resolution_date = '2016-02-11 07:00:00' ] Could not execute statement on remote server 'LLPGDEV'. OLE DB provider "OraOLEDB.Oracle" for linked server "LLPGDEV" returned message "ORA-02089: COMMIT is not allowed in a subordinate session ORA-06512: at "XXCRM.XXCRM_CREATE_INCIDENT_DETAILS", line 376".
Many Thanks,
Mike Williams.