Progress will discontinue Telerik Platform on May 10th, 2018. Learn more

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

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