Passing Table of records in PL/SQL

From: RC <rclarence_at_tyc.com>
Date: Fri, 04 Feb 2000 22:30:40 GMT
Message-ID: <s9mkogkedh156@corp.supernews.com>

I have defined a table of records as follows

Type rec_type is RECORD (

colA table.colA%TYPE,
colB table.colB%TYPE,
colC table.colC%TYPE

);

TYPE tab_recs IS TABLE OF rec_type INDEX BY BINARY_INTEGER;

I then define a variable of type tab_recs i.e.

l_tab tab_recs;

I do some processing to load my table full of information and then I want to pass this tab to a procedure to print all the rows.

So I defined a procedure as follows

PROCEDURE printem (p_table IN tab_recs);

When I call printem via

printem(l_tab);

I get a value error. Is this possible? Am I doing it wrong or do I just have to pass each record in a loop?

TIA RHC --
Posted via CNET Help.com
http://www.help.com/ Received on Fri Feb 04 2000 - 16:30:40 CST