Re: Arrays and Oracle!

From: George Meltser <meltser_at_aigfpc.com>
Date: Tue, 24 Nov 1998 11:52:47 -0500
Message-ID: <73eofm$vhk$1@as4100c.javanet.com>

If you use PL/SQL tables or records or any other PL/SQL variable within a package, they would be different for each user running a package. Does it answer your question?

--
Karl Westberg, MCP

George wrote in message <365A0DC0.5EF7_at_expohire.com.au>...
>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?
>
>Thanks in advance
>
>George.
Received on Tue Nov 24 1998 - 10:52:47 CST