Home » Developer & Programmer » Forms » ORA-01403 error
ORA-01403 error [message #215714] Tue, 23 January 2007 11:15 Go to next message
oracle06
Messages: 36
Registered: December 2005
Member
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.
Thanks.
Re: ORA-01403 error [message #215715 is a reply to message #215714] Tue, 23 January 2007 11:20 Go to previous message
Littlefoot
Messages: 20891
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 ...

into

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: generate text file
Next Topic: Regarding Forms Template & Does Forms10g Supports Database Template (merged)
Goto Forum:
  


Current Time: Sun Dec 04 10:18:51 CST 2016

Total time taken to generate the page: 0.08457 seconds