Home » Developer & Programmer » Forms » Trigger KEY_EXIT error ORA-01400
Trigger KEY_EXIT error ORA-01400 [message #224162] Tue, 13 March 2007 05:47 Go to next message
Catty
Messages: 64
Registered: April 2006
Location: Poland
Member
Hello everyone
I have form made in Froms 6.0, I have created procedure like this:

PROCEDURE ZAPISAC IS
TMP_NUM NUMBER;
  BEGIN
	TMP_NUM:=SHOW_ALERT('POTW');	
	IF TMP_NUM=ALERT_BUTTON1 THEN

		insert into kalendarz_pracy_form
                   (kod,rok,miesiac,dzien,zaklad,id_formy,cyklez1,czyszczz1,
                    cyklez2,czyszczz2,cyklez3,czyszczz3)
 values
                (:kal.kod,:kal.rok,:kal.miesiac,:kal.dzien,:nagl.zaklad,:nagl.id_formy,
 :kal.cyklez1,:kal.czyszczz1,:kal.cyklez2,:kal.czyszczz2,
                    :kal.cyklez3,:kal.czyszczz3);
   
  
    message ('Dokonano zapisu');
    commit_form;
		
	ELSE if TMP_NUM=ALERT_BUTTON2 THEN
		exit_form(no_commit);
		message ('Zrezygnowano z zapisu');
	END IF;
	END IF;
END;


Fields
:kal.kod,:kod.rok,:rok.miesiac,:miesiac.dzien,:dzien.zaklad,:zaklad.id_formy,:id_formy.cyklez1,:kal.czyszczz1,:kal.cyklez2,:kal.czysz czz2,
:kal.cyklez3,:kal.czyszczz3 czyszczz, are fields from the screen. When the user clicks OK the trigger KEY-EXIT fires procedure ZAPISAC.
And it should insert those values into the table. But I get error ORA-01400 inspite of all fields are filled.
Please help it's pretty urgent.
Thank you.
Re: Trigger KEY_EXIT error ORA-01400 [message #224176 is a reply to message #224162] Tue, 13 March 2007 06:17 Go to previous messageGo to next message
Littlefoot
Messages: 20893
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
As you've said that ALL items which are used in the 'kalendarz_pracy_form' table (and which should not be null) have values, perhaps another data block in your form raises an error upon COMMIT_FORM statement in the 'zapisac' procedure?

Click 'Help - Display Error' and you'll see which statement failed with ORA-01400.
Re: Trigger KEY_EXIT error ORA-01400 [message #224241 is a reply to message #224176] Tue, 13 March 2007 08:26 Go to previous messageGo to next message
Catty
Messages: 64
Registered: April 2006
Location: Poland
Member
Hello Littlefoot
Yes I have tried Shift+F1, but it says there is no errors Sad I'm little confused.
Re: Trigger KEY_EXIT error ORA-01400 [message #225451 is a reply to message #224241] Tue, 20 March 2007 00:05 Go to previous message
djmartin
Messages: 10180
Registered: March 2005
Location: Canberra ACT Australia
Senior Member
Account Moderator
Have you solved your problem?

To save changes associated with manual DML statements like your 'insert', use 'standard.commit' to force the commit.

David
Previous Topic: How to stop Auto Alert in Forms please?
Next Topic: Attaching a menu to a form
Goto Forum:
  


Current Time: Mon Dec 05 04:46:59 CST 2016

Total time taken to generate the page: 0.23882 seconds