Home » Developer & Programmer » Forms » FRM 40508
icon8.gif  FRM 40508 [message #187934] Wed, 16 August 2006 07:03 Go to next message
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
	a number;
	a := :emp_mas.txt_empno;
	If :system.record_status <> 'NEW' then
	for i in 1..2 loop
	INSERT INTO scott.family_det VALUES            :family_det.txt_name,:family_det.txt_relation,
	end loop;
	end if;
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
Messages: 10180
Registered: March 2005
Location: Canberra ACT 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.

Re: FRM 40508 [message #188577 is a reply to message #187934] Sun, 20 August 2006 01:00 Go to previous message
Messages: 40
Registered: August 2006
Location: Kuwait

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: Wed Oct 26 07:12:53 CDT 2016

Total time taken to generate the page: 0.08792 seconds