In the following example, the Sybase stored procedure is executed to fetch the contents of the emp and dept tables from Sybase:Ĭreate procedure REFCURPROC varchar(255), varchar(255) output) On execution of a stored procedure, all result sets returned by a previously executed stored procedure will be closed (regardless of whether the data has been completely.Result sets returned by a remote stored procedure have to be retrieved in the order in which they were placed on the wire.The limitations of accessing result sets are the following: The last result set returned is the out argument from the procedure. One out argument of type ref cursor (corresponding to the first result set returned by the stored procedure)Ĭlient programs have to use the virtual package function dbms_hs_result_set.get_next_result_set to get the ref cursor for subsequent result sets.All the input arguments of the remote stored procedure.The Oracle Database Gateway for Sybase returns the following information to Heterogeneous Services during procedure description: ![]() When accessing stored procedures with result sets through the Oracle Database Gateway for Sybase, you will be in the sequential mode of Heterogeneous Services. ![]() Note:If you set the HS_FDS_RESULTSET_SUPPORT gateway initialization parameter, you must change the syntax of the procedure execute statement for all existing stored procedures or errors will occur.
0 Comments
Leave a Reply. |