Sure does.
Thanks for your help.
George Meltser wrote:
>
> 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 - 15:19:20 CST
