Try OpenEdge Now
skip to main content
DataServer for Microsoft SQL Server
RDBMS Stored Procedure Details : Run Stored-Procedure details : Run Stored-Procedure statement
 

Run Stored-Procedure statement

The RUN STORED-PROC statement runs a RDBMS stored procedure or allows you to send Transact-SQL to a MS SQL Server based data source using an OpenEdge DataServer. It contains a procedure-name which is either the:
*Name of the RDBMS stored procedure that you want to run
*OpenEdge built-in procedure name, send-sql-statement, to send Transact-SQL to a MS SQL Server based data source
Note: If your ABL procedure is in a transaction block when a RUN STORED-PROCEDURE statement is executed, the RDBMS stored procedure runs within the same RDBMS transaction, even if your stored procedure declares its own transaction levels.
* LOAD-RESULT-INTO phrase
* PROC-STATUS phrase
* PROC-HANDLE phrase
* NO-ERROR option
* PARAM phrase