An RPC Execution with Input and Output Parameters

An example of an RPC from Adaptive Server through ECDA Option for Oracle. Input and output parameters are mapped as Adaptive Server variables.

declare @io_id int
declare @o_name varchar(30)
select @io_id = 3
exec DCSERVER.dco_rpc_pkg..output_rpc_ex
	@io_id, @o_name output

select @io_id, @o_name
(1 row affected)
(return status = 0)
(0 rows affected)
(0 rows affected)

----------- ------------------------------ 
3 Carl Winkerbean                
(1 row affected)