|
|
|
|
| Re: Oracle Forms Timeout [message #430678 is a reply to message #430669] |
Wed, 11 November 2009 12:54   |
infosuresh2k
Messages: 77
Registered: September 2009
Location: CHENNAI, INDIA
|
Member |
 
|
|
infosuresh2k wrote on Wed, 11 November 2009 10:22Hi,
Is there any way to make a form timeout.
After opening the form if form is idle for 5 minutes then, i want to through one warning message and then form should close automatically.
Regards,
Suresh.V
[Updated on: Wed, 11 November 2009 13:18] Report message to a moderator |
|
|
|
| Re: Oracle Forms Timeout [message #430704 is a reply to message #430669] |
Wed, 11 November 2009 18:15 |
cookiemonster
Messages: 13963
Registered: September 2008
Location: Rainy Manchester
|
Senior Member |
|
|
Quoting your own message is not going to change the answer. Forms isn't really designed to do things like that. Timer is the only way I can think of and coding your requirements with one isn't going to be easy.
It might be possible with some java but I wouldn't know how.
|
|
|
|
|
|
|
|
|
|
|
|
| Re: Oracle Forms Timeout [message #432627 is a reply to message #432564] |
Wed, 25 November 2009 05:14 |
infosuresh2k
Messages: 77
Registered: September 2009
Location: CHENNAI, INDIA
|
Member |
|
|
Hi,
1.Download the latest timeout.jar from metalink.
2.Add one datablock and bean item in our form like PJC.timeout
3.In the timeout bean add when-custom-item-event trigger and add the below coding into that
DECLARE
eventName varchar2(30) := :system.custom_item_event;
v_alert_answer varchar2(1);
BEGIN
IF (eventName='MAX_INACTIVITY_EXCEEDED') THEN
FORMS_DDL('ROLLBACK');
message(('Oracle Forms Session is timeout'); message(' ');
END IF;
END;
4.Add the below code in the when-new-form-instance trigger or some button pressed trigger where ever u want
DECLARE
v_expiry_time VARCHAR2(10) := '1'; --settintg timer this should be roud of value
v_debug_yn VARCHAR2(10) := 'true'; -- enabling debug message this u can set false also if u dont want debug message in java console
args Varchar2(400);
args_has_value boolean := false;
BEGIN
----------------Timeout---
IF v_expiry_time IS NOT NULL THEN
args := args||'all'; -- this you change based on what event u want
args_has_value:=true;
IF (args_has_value) THEN
-- Set custom Bean property
set_custom_property('PJC.TIMEOUT',1,'RECORDING_EVENTS',args);
END IF;
set_custom_property('PJC.TIMEOUT',1,'ENABLE_DEBUGGING',v_debug_yn);
set_custom_property('PJC.TIMEOUT',1,'TIMER_SLEEP_TIME','10');
set_custom_property('PJC.TIMEOUT',1,'START_TIMER',v_expiry_time);
-------
END IF;
END;
5.Configure the formsweb.conf, default.env files then restart applicaation server or OC2J instance and run the form.
U can able to check the debug message in the jinitiator also(check the Show java console for this).
let me know any issue on this..
Regards,
Suresh.V
|
|
|
|
| Re: Oracle Forms Timeout [message #448271 is a reply to message #432627] |
Mon, 22 March 2010 07:58 |
|
|
Hi,
i am having the same problem.
we are uploading webutl file through 10g application forms but is geting disconected after some time.
can you share this with me.
thanks,
sher khan
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
