Global PL/SQL table

Hello everyone,

I am using Forms 5.0 and I am wondering if there is a way to make a pl/sql table as a global variable. I am trying to do something like:

DECLARE
    TYPE t_OrgID IS TABLE OF NUMBER
      INDEX BY BINARY_INTEGER;
    v_org_id t_OrgID;
BEGIN
    v_count := pick_list.get_picklist_element_count(pick_list.list_out);

    --Store the organizations that the user selected     FOR i IN 1..v_count LOOP
      v_org_id(i) :=
TO_NUMBER(pick_list.get_picklist_element_value(pick_list.list_out, i));

      :GLOBAL.v_org_id(i) := v_org_id(i);     END LOOP; Is this even possible or will I have to use dynamic SQL to create and drop a scratch table.

Thanks in advance,

Kyriakos Lambros Received on Mon Apr 03 2000 - 13:28:31 CDT