as far as i know, you cant pass the whole table, but you can pass a record
(row)
<amerar_at_ci.chi.il.us> wrote in message news:823s2r$ps4$1_at_nnrp1.deja.com...
>
>
>
> Hello,
>
> I'm not sure of the syntax of the statement I am trying to write. I
> have a table definition like this:
>
> type StrSanRec IS RECORD (
> v_adm_cost SMALLINT := 0,
> v_off_amt1 SMALLINT := 0,
> v_off_mis1 SMALLINT := 0,
> v_off_amt2 SMALLINT := 0,
> v_off_mis2 SMALLINT := 0,
> v_off_amt3 SMALLINT := 0,
> v_off_mis4 SMALLINT := 0);
> type StrSanTab IS TABLE OF StrSanRec index by binary_integer;
> v_strsan_data StrSanTab;
>
> I will have a max of 7 rows in this table.
>
> I need to write a Function that I will be calling 7 times during the
> execution of the procedure. Each time through this Function I will need
> to modify a different row of the table, and possibly all the elements in
> that row.
>
> How can I pass the entire table or row to the Function, and then return
> it properly? Can I pass an entire table?
>
> Thanks,
>
> Arthur
>
>
> Sent via Deja.com http://www.deja.com/
> Before you buy.
Received on Fri Dec 03 1999 - 16:32:51 CST
