Re: Passing a PL/SQL Table to another form

[Quoted] You still might be able to use a database table. Since the table is temporary, you can create a different table for each user, on the fly using DBMS_SQL package and use the oracle session_id as part of the table name.

rdowdy wrote in message <36815BC2.56986B5A_at_cmc.net>...
>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 CET