Home » Developer & Programmer » Forms » frm-40735: on error trigger raised unhandled exception ora-03114 (oracle 10g, forms 6i)
frm-40735: on error trigger raised unhandled exception ora-03114 [message #460658] Sun, 13 June 2010 23:37 Go to next message
mm_kanish05
Messages: 493
Registered: January 2007
Location: Chennai
Senior Member

Hi,
I am using database 10g and Form 6i. We are working under client server technology. Frequently we are receiving the following error to every user at randomly when they are idle few seconds/minutes.

FRM-40735 or error trigger raised unhandled exception ora-03114


Please help to solve this issue.

Thank You,

Kanish

[Updated on: Sun, 13 June 2010 23:46]

Report message to a moderator

Re: frm-40735: on error trigger raised unhandled exception ora-03114 [message #460663 is a reply to message #460658] Mon, 14 June 2010 00:49 Go to previous messageGo to next message
Littlefoot
Messages: 21818
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
This is what Oracle says:Quote:

ORA-03114
not connected to ORACLE

Cause: A call to Oracle was attempted when no connection was established. Usually this happens because a user-written program has not logged on. It may happen if communication trouble causes a disconnection. In addition, this message could occur when ALTER SYSTEM KILL SESSION or ALTER SYSTEM DISCONNECT SESSION were issued with the IMMEDIATE qualifier because, in those cases, the client's connection to the database is terminated without waiting for the client to issue a request.

Action: Try again. If the message recurs and the program is user written, check the program.

What do you have in the ON-ERROR trigger?

[Updated on: Mon, 14 June 2010 00:50]

Report message to a moderator

Re: frm-40735: on error trigger raised unhandled exception ora-03114 [message #460761 is a reply to message #460658] Mon, 14 June 2010 08:14 Go to previous messageGo to next message
joy_division
Messages: 4963
Registered: February 2005
Location: East Coast USA
Senior Member
Is this 10gR2? I believe that 6i will only work with 10gR1, but I am not certain.
Re: frm-40735: on error trigger raised unhandled exception ora-03114 [message #460810 is a reply to message #460761] Tue, 15 June 2010 00:23 Go to previous messageGo to next message
mm_kanish05
Messages: 493
Registered: January 2007
Location: Chennai
Senior Member

Version

10.1.0.2.0


kanish
Re: frm-40735: on error trigger raised unhandled exception ora-03114 [message #460990 is a reply to message #460663] Wed, 16 June 2010 00:22 Go to previous messageGo to next message
mm_kanish05
Messages: 493
Registered: January 2007
Location: Chennai
Senior Member

On-Error Calls the following procedure;


PROCEDURE MSG_ERROR (msg varchar2 := null) IS
  al_id     Alert;
	al_button number;
	prm_msg varchar2(4000);
	mes_code number;
	mes_type varchar2(3);
	mes_text varchar2(80);
	dbms_err_text varchar2(200);
	
BEGIN


	mes_code := message_code;
	mes_text := rtrim(message_text);
	dbms_err_text := rtrim(dbms_error_text);
	
	-- Supress unwanted messages
	if mes_code = 40200 then -- Field is protected against update.
		prm_msg := get_item_property(name_in('system.trigger_item'),prompt_text);
		prm_msg := prm_msg || ' cannot be changed.';
		message (prm_msg);
		return;		
	elsif mes_code = 40202 then -- Field must be entered
		prm_msg := get_item_property(name_in('system.trigger_item'),prompt_text);
		prm_msg := prm_msg || ' must be entered.';
		message (prm_msg);
		return;
	elsif mes_code = 40405 then -- No changes to applly
		return;
	elsif mes_code = 41008 then -- Undefined function key
		return;
	elsif mes_code = 41051 then -- You cannot create records here
		message (message_text);
		return;
	elsif mes_code = 41830 then -- List of values contains no entries
		prm_msg := message_text;
		message (prm_msg);
		return;
	elsif mes_code = 50012 then -- Illegal date format
		prm_msg := message_text;
		message ('Illegal date. ' || prm_msg);
		return;
	elsif mes_code =	50016 then -- Legal characters are 0-9 
		prm_msg := message_text;
		message(prm_msg);
		return;
	elsif mes_code = 50026 then -- Date format must be entered in ....
		message (message_text);
		return;
	end if;
	
	declare
		f_severity form_errors.severity%type;
	begin
		select severity
		into f_severity
		from form_errors
		where error_code = mes_code;
		if f_severity = '0' then
			return;
		elsif f_severity = '1' then
			message (message_text);
			return;
		elsif f_severity = '2' then
			message (message_text);
			message (message_text);
			return;			
		end if;
	exception
		when no_data_found then
			null;
		when others then
			message ('Error. Please contact Data centre. Cannot select from form_errors @ msg_error');		
			message ('Error. Please contact Data centre. Cannot select from form_errors @ msg_error');					
	end;	
		
	log_msg_error (
	name_in ('global.login_id'),
	name_in ('system.current_form'),
	error_code , 
	msg ,
	dbms_err_text , 
	name_in ('system.trigger_block'),
	name_in ('system.trigger_item'),
	name_in ('system.trigger_record'));
		
	
	
	prm_msg := msg || chr(13)|| dbms_err_text || chr(13);		
	prm_msg := prm_msg || mes_type || ': ' ||mes_code || ' ' || message_text || chr(13) || chr(13);

	prm_msg := prm_msg || chr(13) || 'Block : ' || name_in('system.trigger_block');
	prm_msg := prm_msg || chr(13) || 'Item : ' || name_in('system.trigger_item');
	prm_msg := prm_msg || chr(13) || 'Record : ' || name_in('system.trigger_record');
	al_id := Find_Alert ('STD_ALERT_STOP');
	if Id_Null(al_id) then	
		message (prm_msg);
		message (prm_msg);
	else	
  	set_application_property (cursor_style,'default');
  	Set_Alert_Property(al_id,Alert_Message_Text,prm_msg);
  	Set_Alert_Property(al_id,Title,'Error.         Please contact Data Centre');
  	al_button := show_alert(al_id);
	end if;	
	
	
	raise form_trigger_failure;

END;


Help me to solve this issue.

kanish
Re: frm-40735: on error trigger raised unhandled exception ora-03114 [message #464271 is a reply to message #460990] Wed, 07 July 2010 03:39 Go to previous message
djmartin
Messages: 10181
Registered: March 2005
Location: Surges Bay TAS Australia
Senior Member
Account Moderator
Sorry that I have been so long in replying. Have you solved your problem?

Googling 'ora-03114 "Forms 6" "Oracle 10g"' returned a number of interesting articles including http://www.developpez.net/forums/d385695/bases-donnees/oracle/administration/ora-3113-3114-a/ and http://www.lazydba.com/oracle/0__121234.html Have you recently moved to Oracle 10g? Did you recompile ALL the libraries and forms after the move?

David
Previous Topic: open pdf file thru oracle forms developer 9i and extract blob from DB thru forms
Next Topic: How to solve the error in application?
Goto Forum:
  


Current Time: Thu Sep 19 22:52:10 CDT 2024