Skip to content
View Categories

Call Stored Procedure (OLEDB) Tool

5 articles

How to run a SAP HANA database stored procedure using TaskCentre

Last Updated: September 5, 2022

Learn how to run a SAP HANA database stored procedure using TaskCentre.

TaskCentre Exchange Agent – How to create a subscription to monitor a mailbox

Last Updated: September 5, 2022

This knowledge base article will outline how an inbox for a specified mailbox can be monitored.

How to Connect to SAP HANA Database Using an OLEDB-ODBC Bridge

Last Updated: September 5, 2022

This article provides guidance for using the Call Stored Procedure (OLEDB) tool to connect to a SAP Business One HANA database.

Call Stored Procedure step fails at task runtime with error 0x80040e21

Last Updated: July 1, 2022

Symptom When a task contains a Call Stored Procedure step that accepts parameter values, it may fail at runtime with the following error: 0x80040e21 Cause Occurs when the parameter value can’t be converted into the specified data type. For example, if a stored procedure requires a parameter type of DBTIMESTAMP and you pass it a...

Updating oracle stored procedure with > 32 KB fails with ‘the operation failed 0x80040e14’

Last Updated: July 1, 2022

Symptom Updating an Oracle stored procedure using the Call Stored Procedure (OLEDB) tool returns the following error code: the operation failed 0x80040e14 Cause The underlying error is ‘ORA-01460: unimplemented or unreasonable conversion requested’. This is caused by binding more than 32KB data to a stored procedure parameter when using the Oracle OLEDB Provider. Resolution Add...