Re: NO_DATA_FOUND return in PLSQL

From: Michel <micadot_at_altern.org>
Date: Thu, 22 Jul 1999 11:52:45 +0200
Message-ID: <7n6qg9$433$1@oceanite.cybercable.fr>

We encountered the same error 20 months ago on HP-UX10.20 and NT 4.0. That was in a package with PL/SQL table when there was a high activity.

Actually, there is an Oracle kernel error that is probably related with that message (number 548360 : PL/SQL table corruption resulted in failure of replication) and that was corrected in 7.3.3.4 and 7.3.3.5 but was present in 7.3.4.0 and corrected in 7.3.4.1.

Hope this will help you.

private_comm_at_my-deja.com a écrit dans le message <7n46sc$ob4$1_at_nnrp1.deja.com>...
>Hi All,
>
>I have a stored procedure that inserts one single row of record using
>parameters passed from a generated HTML form. A NO_DATA_FOUND
>excpetion is thrown upon INSERT. However, everything appears to be
>fine and the data is inserted.
>
>We've added a WHEN NO_DATA_FOUND handler to by pass it but does anyone
>know why? We are using OAS 4.07 with PL/SQL cartridge. We have other
>similar handlers that works.
>
>Many Thanks
>
>PC
>
>
>Sent via Deja.com http://www.deja.com/
>Share what you know. Learn what you don't.
Received on Thu Jul 22 1999 - 04:52:45 CDT