OraFAQ Forum: Forms » FRM-404000 trahsaction complete 1 record applied and save

Home » Developer & Programmer » Forms » FRM-404000 trahsaction complete 1 record applied and save

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

FRM-404000 trahsaction complete 1 record applied and save [message #177703]

Fri, 16 June 2006 02:40

mfa786
Messages: 210
Registered: February 2006
Location: karachi

Senior Member

hi master
sir when i commit my form then system give me this message

my code
commit_FORM;
GO_BLOCK('spereport');
EXECUTE_QUERY;

error or message
FRM-404000 trahsaction complete 1 record applied and save

how i avoid this message
thank
aamir

Report message to a moderator

Re: FRM-404000 trahsaction complete 1 record applied and save [message #177705 is a reply to message #177703]

Fri, 16 June 2006 02:48

Maaher
Messages: 7065
Registered: December 2001

Senior Member

You can suppress this message by raising the SYSTEM.MESSAGE_LEVEL variable (

warning, untested code):

DECLARE
  -- store the current message level
  v_old_message_level NUMBER := :SYSTEM.MESAGE_LEVEL;
BEGIN
  :SYSTEM.MESSAGE_LEVEL := 20;
  COMMIT_FORM;
  GO_BLOCK('spereport');
  EXECUTE_QUERY;
  -- reset the message level
  :SYSTEM.MESSAGE_LEVEL := v_old_message_level;
END;

Report message to a moderator

Previous Topic:	General Problem
Next Topic:	How to store picture in Database and retrive.....

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri Sep 20 09:37:07 CDT 2024