PLEASE HELP ME WITH INSERT INTO TRIGGER [message #19758] |
Sun, 07 April 2002 10:56 |
nicole
Messages: 10 Registered: January 2002
|
Junior Member |
|
|
Hello,
I am trying to add a record into my sql database witht the following "when-button-pressed" trigger:
declare
v_ssn VARCHAR2(9);
begin
v_ssn := :patient.ssn;
insert into patient(ssn) values ('v_ssn');
commit;
end;
but i get the ERROR Message: FRM-3050: ORACLE error: unable to insert record.
Does anybody know what is wrong? please help me. Thanks! :)
Nicole
|
|
|
|
Re: PLEASE HELP ME WITH INSERT INTO TRIGGER [message #19763 is a reply to message #19758] |
Mon, 08 April 2002 03:46 |
anuca
Messages: 1 Registered: April 2002
|
Junior Member |
|
|
probably caused by an Oracle error (attempt to insert a null value in a not null column, or invalid type like inserting characters in a numeric column)
Try to prompt out the Oracle error message (now You are getting the Forms error message) handling the exception and prompting the oracle variable sqlerrm
|
|
|