Release 10.1A: OpenEdge Data Management:
DataServer for ORACLE

> ## Run Stored-Proc statement execution without the LOAD-RESULT-INTO phrase

> To implement most data retrieval options associated with a stored procedure, (excluding those that involve loading retrieved data into temp-tables) you must define the `RUN STORED-PROC` statement and explicitly end the stored procedure using the `CLOSE STORED-PROC` statement.

> You must define the `RUN STORED-PROC` and explicitly complete access to the stored procedure `OUTPUT` with the `CLOSE STORED-PROC` syntax expressions for a stored procedure implementation that retrieves the following types of data from the foreign data source:

> - proc-text-buffer

> - user-defined views

> For more information about these data retrieval options, see the "Data output and retrieval options" section.

> Note: You can also implicitly or explicitly close a stored procedure to retrieve these types of data: return code or output parameters. For more information about each of these data retrieval options, see the "Data output and retrieval options" section.

> The syntax details presented in this section describe how you to run and close a stored procedure in the ORACLE data source.

> This is the syntax for the `RUN STORED-PROC` statement to execute an RDBMS stored procedure without the `LOAD-RESULT-INTO` phrase:

> Syntax
>     RUN STORED-PROC procedure-name [<int> = PROC-HANDLE]
>          [ NO-ERROR ]
>       [([INPUT|OUTPUT|INPUT OUTPUT] [PARAM parameter-name =]expression, ...
>        [INPUT|OUTPUT|INPUT OUTPUT] [PARAM parameter-name =]expression )]

> This type of syntax expression requires the explicit `CLOSE` `STORED–PROC` statement. This is the partial syntax for the `CLOSE` `STORED–PROC` statement:

> Syntax
>     CLOSE STORED-PROC procedure-name
>     [ integer-field = PROC-STATUS ]
>       [ WHERE PROC-HANDLE = integer-field ]

Copyright © 2005 Progress Software Corporation www.progress.com Voice: (781) 280-4000 Fax: (781) 280-4095