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  |
 |
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 #635785 is a reply to message #635751] |
Wed, 08 April 2015 08:37  |
 |
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...
|
|
|
|
Goto Forum:
Current Time: Sat Feb 08 17:35:39 CST 2025
|
] 
Blog
Search
Help
Members
Register
Login
Home
