Passing Tables

From: <amerar_at_ci.chi.il.us>
Date: Wed, 01 Dec 1999 19:14:40 GMT
Message-ID: <823s2r$ps4$1@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 Wed Dec 01 1999 - 13:14:40 CST