Home » Developer & Programmer » Forms » frm 40508 and ORA-01403: no data found (window 7)
frm 40508 and ORA-01403: no data found [message #635742] Wed, 08 April 2015 01:31 Go to next message
gunjansangahi
Messages: 2
Registered: November 2014
Location: INDIA
Junior Member
frm-40508, unable to insert

when i do show error it displays

i've no clue why its coming.

INSERT INTO INFO_MAST I(INFO_CODE,INFO_DATE,CUSTOMER_CODE,CUSTOMER_TYPE,WEEKLY_OFF,WORKING_HOUR,CREATE_USER,MODIFY_DATE) VALUES (:1,:2,:3,:4,:5,:6,:7,:8) RETURNING I.ROWID,REF(I),I.INFO_CODE,I.INFO_DATE,I.CUSTOMER_CODE,I.CUSTOMER_TYPE,I.WEEKLY_OFF,I.WORKING_HOUR,I.CREATE_USER,I.MODIFY_DATE INTO :9,:10,:11,:12,:13,:14,:15,:16,:17,:18

ORA-01403: no data found

[Updated on: Wed, 08 April 2015 01:33]

Report message to a moderator

Re: frm 40508 and ORA-01403: no data found [message #635751 is a reply to message #635742] Wed, 08 April 2015 02:42 Go to previous messageGo to next message
cookiemonster
Messages: 13894
Registered: September 2008
Location: Rainy Manchester
Senior Member
What exactly is the block based on?
Re: frm 40508 and ORA-01403: no data found [message #635785 is a reply to message #635751] Wed, 08 April 2015 08:37 Go to previous message
CraigB
Messages: 386
Registered: August 2014
Location: Utah, USA
Senior Member
Since you have the RETURNING clause on your INSERT, the insert is failing for some reason which, in turn, causes the RETURNING clause to report a ORA-01403-No Data Found. Try setting the DML Returning Value property to NO and then try your INSERT to see what error is reported. Most likely, you are missing a Key value in your insert...

Craig...
Previous Topic: FORMS
Next Topic: Failure of server APACHE bridge
Goto Forum:
  


Current Time: Mon Aug 10 15:55:04 CDT 2020