Arrays and Oracle!

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 Mon Nov 23 1998 - 19:37:04 CST