Re: Passing a PL/SQL Table to another form

Thank you for your response.

I am concerned about using a global scope or a database table because multiple users will be using this form at the same time. If the trigger fires at the same time for more than one user, it might cause some conflict or misinformation.

Unfortunately the multiple users will be using a common ROLE, because if they were loggin in as different users, I could add a ':USER' field to the data to distinguish these records.

Thank you for any suggestions.

Richard W. Dowdy

-Client Development Leader-
-SAP/Oracle/Unix help desk project-
-  richdow_at_thegrid.net  -

Marc Billiet wrote:

> You can try to use a global record group (function CREATE_GROUP('a name',
> GLOBAL_SCOPE, ...)) : see online help for more information.
>
> Marc
>
> rdowdy wrote in message <3680C00F.49B4BC24_at_cmc.net>...
> >I am using Oracle Forms 5.
> >
> >I have a form that manipulates two Database Tables and groups the data.
> >This data needs to be passed to another form.
> >
> >The trigger, behind which this code exists, needs to open the next form
> >and populate that form with this manipulated data. The data's final
> >state could fit in a table able to hold up to 200 records. Each record
> >needs two columns of numeric type (6,0).
> >
> >Using a real table is not possible, due to multi-user conflicts that
> >could occur during processing.
> >
> >Any suggestions are greatly appreciated.
> >
> >Richard W. Dowdy
> >-Client Development Leader-
> >-SAP/Oracle/Unix help desk project-
> >- richdow_at_thegrid.net -
> >
Received on Wed Dec 23 1998 - 00:00:00 CST