Trigger KEY_EXIT error ORA-01400 [message #224162] |
Tue, 13 March 2007 05:47  |
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 #225451 is a reply to message #224241] |
Tue, 20 March 2007 00:05  |
 |
djmartin
Messages: 10181 Registered: March 2005 Location: Surges Bay TAS 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
|
|
|