FRM 40508 [message #187934] |
Wed, 16 August 2006 07:03 |
neetigulati
Messages: 3 Registered: August 2006 Location: ldh
|
Junior Member |
|
|
Hi evryone
Well im new to oracle forms n facin quite large no of problems....I hav contacted many bt no one helps....
so plz help me
1) i hav written dis code
declare
a number;
begin
a := :emp_mas.txt_empno;
If :system.record_status <> 'NEW' then
go_block('family_det');
first_record;
for i in 1..2 loop
INSERT INTO scott.family_det VALUES :family_det.txt_name,:family_det.txt_relation,
:family_det.txt_dob,
:family_det.txt_age,:family_det.txt_dependent,:family_det.txt_handicap,:family_det.txt_qualification,
:family_det.txt_occupation);
next_record;
commit;
end loop;
end if;
commit;
end; On "when pressed button trigger" to save records of detail block family_det associated with emp_master form,
Save button is in detail form
But d record doesnt gets saved and error displayed is FRM 40508
unable to insert record
When i display error den i see dat d sql qurry posted ther is sumthing else based emp_master form
Plz help me...........urgently as soon as possible
[Updated on: Thu, 17 August 2006 04:22] by Moderator Report message to a moderator
|
|
|
|
Re: FRM 40508 [message #188577 is a reply to message #187934] |
Sun, 20 August 2006 01:00 |
elsy
Messages: 40 Registered: August 2006 Location: Kuwait
|
Member |
|
|
Run the insert command in SQL PLus with same data values
Check whether the data size matches
Might be the size of the data is greater than the size of the columns specified.
Check it out...
|
|
|