Re: Global PL/SQL table

Dan,

You could have a PL/SQL as a package variable. In that way, it persists, like a global
across the session. Define it in a Package header. You probabaly would need to write
functions and procedures to get and set the values in the table, as I don't think
Forms allows direct access to package variables i.e. package_name.variable.

DanHW <danhw_at_aol.com> wrote in message news:20000403195128.08136.00000839_at_ng-fp1.aol.com...
> >
> >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 Thu Apr 13 2000 - 17:42:03 CEST