| ORA-01403 error [message #215714] |
Tue, 23 January 2007 11:15  |
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  |
 |
Littlefoot
Messages: 21823
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.
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
