Re: missing data

From: Mark Powell <Mark.Powell_at_eds.com>
Date: 1998/03/27
Message-ID: <01bd59ac$3b458260$a12c6394@J00679271.ddc.eds.com>#1/1

Being that this is two days old you have probably discovered that 'no data found' is the error that occurs when you do a 'select into' that returns no rows. You can code a pl/sql exception block to capture/handle this error.

> hi,
> I am having problems with 'missing data'.
> Sometimes, when people perform inserts a result of
> 'NO DATA FOUND' is given. I took this to mean a problem
> with sequences (we have recently moved from 7.1.6.2.0 to 7.3.3.3).
> So, I pinned the seqences into othe library cache. This did not seem
> to work. I stopped the sequences from caching (altering them to
'nocache'),
> to try to force disk reads. This also did not seem to work.
> Has anyone any ideas pls?
> Nick (posting on someone else's account)
>
Received on Fri Mar 27 1998 - 00:00:00 CST