Limitations of Stored Procedures

Limitations of Stored Procedures

The following limitations apply to creating endpoints for stored procedures and functions in Telerik Platform.

  • Execution timeout—the maximum execution time for an endpoint is 285 seconds. If your database server does not return a result within this period, the request results in a timeout.
  • When connecting to an SQL database, you cannot execute the following function types from an HTTP endpoint, even if they are successfully mapped:
    • Table-valued functions (TVF)
      Workaround: Create a stored procedure that calls the TVF and map the stored procedure instead of the TVF.
    • Scalar-valued functions (SVF)
      Workaround: Create a stored procedure that calls the SVF and map the stored procedure instead of the SVF.
    • System functions.
  • Salesforce report parameters are not supported and will be ignored.

See Also

Start a free trial Request a demo
Contact us: +1-888-365-2779
sales@telerik.com
Copyright © 2016-2017, Progress Software Corporation and/or its subsidiaries or affiliates. All rights reserved.