Как заюзать следующие конструкции
с ref cursor для просмотра понятно, а с
type document_tab is table of document_rec index by binary_integer для
udi ( update , delete , insert ) не выходит не понятно как делать, как передать
данную конструкцию как параметр в процедуры.



type document_rec is record
( DI_ID V$SCHEMA#DOC_ITEM.DI_ID%TYPE,
DOC# V$SCHEMA#DOC_ITEM.doc#%TYPE,
TYPE# V$SCHEMA#DOC_ITEM.type#%TYPE,
DOC_DATE V$SCHEMA#DOC_ITEM.doc_date%TYPE,
GOODS# V$SCHEMA#DOC_ITEM.goods#%TYPE,
GOODS_NAME VARCHAR2(100),
PACKAGING V$SCHEMA#DOC_ITEM.packaging%TYPE,
AMOUNT V$SCHEMA#DOC_ITEM.amount%TYPE,
PRICE V$SCHEMA#DOC_ITEM.price%TYPE,
COST V$SCHEMA#DOC_ITEM.COST%TYPE,
COST_NDS V$SCHEMA#DOC_ITEM.COST_NDS%TYPE,
COST_NP V$SCHEMA#DOC_ITEM.COST_NP%TYPE,
COST_TOTAL V$SCHEMA#DOC_ITEM.COST_TOTAL%TYPE,
NP NUMBER,
NDS NUMBER,
TO_CODE TOVAR.TO_CODE%TYPE,
WEIGHT TOVAR.TO_WEIGHT%TYPE
);

type document_upr_rec is record
(
DOC# V$SCHEMA#DOCUMENT.DOC#%type,
TYPE# V$SCHEMA#DOCUMENT.TYPE#%type,
PLACE# V$SCHEMA#DOCUMENT.PLACE#%type,
DOC_DATE V$SCHEMA#DOCUMENT.DOC_DATE%type,
DOC_NUMBER V$SCHEMA#DOCUMENT.DOC_NUMBER%type,
D_CONTRACTOR# V$SCHEMA#DOCUMENT.D_CONTRACTOR#%type,
C_CONTRACTOR# V$SCHEMA#DOCUMENT.C_CONTRACTOR#%type,
D_NAME OTDEL.OT_NAME%type,
C_NAME CLIENT.CL_NAME%type,
PT# V$SCHEMA#DOCUMENT.PT#%type,
PARENT_DOC V$SCHEMA#DOCUMENT.PARENT_DOC#%TYPE
-- PARENT_TYPE V$SCHEMA#DOCUMENT.PARENT_TYPE#%TYPE
);



type document_cur is ref cursor return document_rec ;
type document_upr_cur is ref cursor return document_upr_rec ;

==========================================================
type document_tab is table of document_rec index by binary_integer ;
type document_upr_tab is table of document_upr_rec index by binary_integer ;
^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
-----------------------------------------------------------------------------------------------
procedure document_refcur(document_data in out document_cur, VID in V$SCHEMA#DOCUMENT.DOC#%type );
procedure document_upr_record(voz_upr_data in out document_upr_cur , VID in V$SCHEMA#DOCUMENT.DOC#%type );
-----------------------------------------------------------------------------------------------
procedure document_lock (document_data in out document_tab );
procedure document_upr_lock (document_data in out document_upr_tab);
-----------------------------------------------------------------------------------------------
procedure document_update (document_data in out document_tab,
VID in V$SCHEMA#DOCUMENT.DOC#%type);
procedure document_upr_update(document_data in out document_upr_tab);
-----------------------------------------------------------------------------------------------
procedure document_delete (document_data in out document_tab );
-----------------------------------------------------------------------------------------------
procedure document_insert (document_data in out document_tab ,
VID in V$SCHEMA#DOCUMENT.DOC#%type,
TYP in V$SCHEMA#DOC_ITEM.type#%TYPE,
DOCDT in V$SCHEMA#DOC_ITEM.doc_date%TYPE);
procedure document_upr_insert (document_data in out document_upr_tab );
-----------------------------------------------------------------------------------------------