Output variables are used to return data to another procedure, or to an external
application which has invoked the stored procedure.
/* sample procedure header using output variables */
TYPE INV_ARRAY IS TABLE OF NUMBER(8)
INDEX BY BINARY_INTEGER ;
CREATE OR REPLACE PROCEDURE PROC_GET_INV_NOS
( USERID1 IN VARCHAR2, INV_IDS OUT INV_ARRAY)
AS
...
|
|
