| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Usenet -> c.d.o.server -> Re: Passing Arrays
amerar_at_ci.chi.il.us wrote:
>
> 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.
Put the type in the public part of a package - then you can use it in parameter declarations for any proc/func as you would with any other simple datatype.
HTH
--
"Some days you're the pigeon, and some days you're the statue." Received on Wed Dec 01 1999 - 06:30:07 CST
 |
 |