Re: Weird Error -- Update statement returning no data found error

Bill wrote:

> HI
>
> In the block based on a view(in oracle forms), I have an update sql in
> when validate item trigger for a non database text item.
>
> Based on the value I enter in this item , I update different tables.
>
> Update emp
> where ename='test'
> and sal=:block.item -- non database text item
>
> Very interestingly I'm getting no data found error when this piece of
> sql is getting executed.
>
> I know very well that an update statement cannot return a no data
> found.
>
> Can you guys share any solution in mind for the above...or how to
> trouble shoot it...

What version and edition of Oracle?
What is the exact error message you are getting? ORA-##### and the full message text.

Tried to look over you shoulder but I forgot my glasses.

Daniel Morgan Received on Tue Feb 11 2003 - 21:14:47 CET