Re: Arrays and Oracle!

From: Christopher Beck <clbeck_at_us.oracle.com>
Date: Tue, 24 Nov 1998 13:23:49 GMT
Message-ID: <365ab0b6.1274172@inet16.us.oracle.com>

On Tue, 24 Nov 1998 12:37:04 +1100, George <info_at_expohire.com.au> wrote:

>A trigger in our database calls a stored procedure which manipulates a
>temporary table. I didn't realise up till recently that a trigger
>executes under the context of its creator and not the user who initiated
>it. So creating the same temporary table for each schema doesn't work
>because the trigger will only manipulate the schema table that the
>trigger belongs to.
>
>My question. I need a non-persistant datastructure (such as an array)
>that exists only in the trigger. Does PL/SQL provide any support for
>arrays (in the form of datatypes, objects etc...). If not is there
>anyway of implementing them in PL/SQL?

You can use PL/SQL tables.

eg.

• define a PL/SQL table type type myTableType is table of varchar2(2000) index by binary_integer;
• create a variable of that type l_table myTableType;

Reference the variable like

  l_table(i)

Check out the PL/SQL users guide for more info on them.

hope this helps.

chris.

>
>Thanks in advance
>
>George.

--
Chirstopher Beck
Oracle Corporation
clbeck_at_us.oracle.com
Reston, VA.

---

Opinions are mine and do not necessarily reflect those of Oracle Corporation Received on Tue Nov 24 1998 - 07:23:49 CST