Global PL/SQL table
Date: Mon, 03 Apr 2000 18:28:31 GMT
Message-ID: <38E8E2C3.F2EE357_at_lvvwd.com>
[Quoted] Hello everyone,
[Quoted] 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 - 20:28:31 CEST