Skip to Main Content

Oracle Forms

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

:Global varibles sometimes hasn't been sent!

Dev. MusbahOct 3 2013 — edited Oct 29 2013

Hi All,

I'm using :Global variables to send and recieve values between forms. The strange thing is that these global variables hasn't been sent sometimes and has been sent successfully other times!

I'm using it throgh the WHEN-NEW-FORM-INSTANCE trigger of the form like this:

In the sending form

declare

n number;

begin

select seq.currval -- this is a sequence

into n

from dual;

:global.v1 := n;

end;

In the recieving one:

:global.v2 := :global.v1;

at the running of the recieving form it gives me this error:

FRM-40815: Variable GLOBAL.V1 does not exist!

The previuos code is working successfully for some users and geives the previous error for others!!!!!!!!!!!!!!

Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Nov 26 2013
Added on Oct 3 2013
7 comments
676 views