Home » Developer & Programmer » Forms » Oracle Forms Timeout (Forms 10g, Wwin XP)
Oracle Forms Timeout [message #430669] Wed, 11 November 2009 10:22 Go to next message
infosuresh2k
Messages: 77
Registered: September 2009
Location: CHENNAI, INDIA
Member

Hi,

Is there any way to make a form timeout.

After login into form if there is no transaction/event heppens I want it to through one warning message after say 5 miniutes.

Regards,
Suresh.V
Re: Oracle Forms Timeout [message #430670 is a reply to message #430669] Wed, 11 November 2009 10:30 Go to previous messageGo to next message
cookiemonster
Messages: 12422
Registered: September 2008
Location: Rainy Manchester
Senior Member
use a timer
Re: Oracle Forms Timeout [message #430678 is a reply to message #430669] Wed, 11 November 2009 12:54 Go to previous messageGo to next message
infosuresh2k
Messages: 77
Registered: September 2009
Location: CHENNAI, INDIA
Member

infosuresh2k wrote on Wed, 11 November 2009 10:22
Hi,

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 Go to previous messageGo to next message
cookiemonster
Messages: 12422
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 #431082 is a reply to message #430704] Sat, 14 November 2009 09:33 Go to previous messageGo to next message
javed.khan
Messages: 340
Registered: November 2006
Location: Banglore
Senior Member

Follow this thread

http://www.orafaq.com/forum/t/152226/96650/


And suggest your expertise here.

Jak
Re: Oracle Forms Timeout [message #431086 is a reply to message #430704] Sat, 14 November 2009 11:02 Go to previous messageGo to next message
infosuresh2k
Messages: 77
Registered: September 2009
Location: CHENNAI, INDIA
Member

Timer wont work my friend,
i desgined the timeout form using jave bean

thanks & regards,
Suresh.V
Re: Oracle Forms Timeout [message #431108 is a reply to message #431086] Sun, 15 November 2009 01:02 Go to previous messageGo to next message
javed.khan
Messages: 340
Registered: November 2006
Location: Banglore
Senior Member

Can you share the same with us.
Re: Oracle Forms Timeout [message #432564 is a reply to message #431086] Tue, 24 November 2009 23:28 Go to previous messageGo to next message
djmartin
Messages: 10180
Registered: March 2005
Location: Canberra ACT Australia
Senior Member
Account Moderator
Yes. Please share.

David
Re: Oracle Forms Timeout [message #432627 is a reply to message #432564] Wed, 25 November 2009 05:14 Go to previous messageGo to next message
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 Go to previous message
sherkhan@infodynamic.net
Messages: 28
Registered: August 2009
Location: dubai
Junior Member

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
Previous Topic: WebUtil client_get_file_name
Next Topic: Show that a process is running
Goto Forum:
  


Current Time: Sun Dec 11 06:29:10 CST 2016

Total time taken to generate the page: 0.11589 seconds