Stored Procedures within a Package

Examples that illustrate the use of stored procedures based on the Oracle table and data.

example_table
(id_num int,
name varchar(30),
phone varchar(20) null,
birthdate date null)

id_num       name 				    phone			birthdate
1		    Carl Finklestein	     203-231-0123	 NULL
2		    Fred P. Body		 	NULL			 NULL
3		    Carl Winkerbean		  603-231-4123	 AUG 09 1947
4		    Wanda Finklestein		978-245-6789	 JUL 12 1972
5		    John Smith			   607-789-0123	 NOV 09 1963

• Oracle Package and Procedure Definitions
  An example of Oracle package and procedure definitions.
• An RPC Mapping That Returns a Result Set as an Adaptive Server Table
  An example that maps the Oracle procedure rset_rpc_ex as an Adaptive Server table with its input parameters mapped as columns, as described in the Adaptive Server documentation.
• An RPC Execution That Returns a Result Set
  An example that executes an RPC, from Adaptive Server through ECDA Option for Oracle to Oracle. This RPC takes two input parameters and returns a result set.
• 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.
• An RPC Execution with an Input Parameter
  An example that executes an RPC from Adaptive Server through ECDA Option for Oracle. It passes an input parameter, deleting one row.