Home » Developer & Programmer » Forms » FRM 40508
icon8.gif  FRM 40508 [message #187934] Wed, 16 August 2006 07:03 Go to next message
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 #188139 is a reply to message #187934] Thu, 17 August 2006 04:25 Go to previous messageGo to next message
djmartin
Messages: 10181
Registered: March 2005
Location: Surges Bay TAS Australia
Senior Member
Account Moderator
How many columns are there in 'scott.family_det' and have your an entry for each in the ;VALUES' list? Either add more 'values' or define the 'columns' to be propulated.

David
Re: FRM 40508 [message #188577 is a reply to message #187934] Sun, 20 August 2006 01:00 Go to previous message
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...
Previous Topic: Urgent Please (merged)
Next Topic: Changing the Font Size for Alert Messages
Goto Forum:
  


Current Time: Fri Sep 20 11:29:58 CDT 2024