Home » Developer & Programmer » Forms » ORA-01403 error
ORA-01403 error [message #215714] Tue, 23 January 2007 11:15 Go to next message
Messages: 36
Registered: December 2005
Hello All,
I am getting ORA-01403:no data found error,when I am saving records on key-commit trigger.
on this trigger I am calling a procedure named 'save',and from this procedure some other procedure calls exist.when I commit the changes key-commit trigger fires,after successful execution of some procedures in save proceure,the data of the detail block
disappears and gives above error.on that point there is a select into clause where it fails.how can I solve this problem.

please guide.
Re: ORA-01403 error [message #215715 is a reply to message #215714] Tue, 23 January 2007 11:20 Go to previous message
Messages: 21148
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
Deal with it in exception handler (WHEN NO-DATA-FOUND). Or, if SELECT INTO clause you mentioned is relatively simple, you might change it from (for example)

SELECT title INTO some_variable FROM this_table WHERE ...


SELECT MAX(title) INTO some_variable FROM this_table WHERE ...

Aggregate function (MAX in this example) will not raise NO-DATA-FOUND exception.
Previous Topic: forms 6i as webservice
Next Topic: I can't update my master-detail
Goto Forum:

Current Time: Mon Aug 21 22:43:09 CDT 2017

Total time taken to generate the page: 0.09722 seconds