| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
Home -> Community -> Usenet -> c.d.o.misc -> Initialized a varialbe of type?
in Package head section, I have created this:
TYPE tbl_order_id IS TABLE OF tableA.order_id%TYPE
INDEX BY BINARY_INTEGER; and in Package body, I have a procedure that PROCEDURE GetOrder(..,
o_order_id IN OUT tbl_order_id,
..) IS
v_orderID tableA.order_id%TYPE;
v_count BINARY_INTEGER DEFAULT 0;
..
t_order_id tbl_order_id;
..
BRGIN
..
o_order_id:= t_order_id;
-- a cursor to select something into the v_orderID and loop through
a table
o_order_id(v_count):= v_orderID;
I wonder when I initialize the o_order_id, what I initialize o_order_id with? is the element of the o_order_id or o_order_id itself? What value does its element of o_order_id have ? null or what?
C Chang Received on Sat May 04 2002 - 22:43:36 CDT
![]() |
![]() |