Re: 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,
>

You can use record groups, keeping it entirely in forms. You can also use a PL/SQL table via stored procedures, but that will require trips to the database.

HTH
Dan Hekimian-WIlliams Received on Tue Apr 04 2000 - 01:51:28 CEST