Try OpenEdge Now
skip to main content
DataServer for Oracle
RDBMS Stored Procedure Details : RUN STORED-PROCEDURE details : RUN STORED-PROCEDURE statement : PARAM phrase
 
PARAM phrase
The Param phrase identifies a run-time parameter to be passed to the stored procedure. A parameter has the following syntax:
[([INPUT|OUTPUT|INPUT OUTPUT][PARAM parameter-name =]expression, ...     
[INPUT|OUTPUT|INPUT OUTPUT][PARAM parameter-name =]expression )]
An expression is a constant, field name, variable name, or expression. INPUT is the default. OUTPUT and INPUT-OUTPUT parameters must be record fields or program variables.
If you run send-sql-statement for an Oracle-based data source, you must pass a single character expression parameter containing the SQL statement you want the data source to execute.
Note: The Oracle DataServer only supports one SQL statement with the send-sql-statement option.
If you do not specify parameter-name (the name of a keyword parameter defined by the stored procedure), you must supply all of the parameters in correct order. If you do specify parameter-name, you must precede your assignment statement with the keyword PARAM. If you do not supply a required parameter, and no default is specified in the stored procedure, you receive a run-time error.