Re: NO_DATA_FOUND return in PLSQL

The No_Data_Found error could come from a couple of places:

    a.. If you have a trigger on the table into which you are inserting, = then this trigger may call something that results in the error

    b.. If you reference any PL/SQL functions in the insert statement, = these may call things that cause the error Can you reproduce the error in SQL*Plus? If you can, you should be able = to get a stack trace out, telling you exactly where the exception is = raised

Hope this helps

--
Karl E. Jørgensen
Return address forged to prevent spam,
use k a r l @ j o r g e n s e n . c o m instead...

private_comm_at_my-deja.com wrote in 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 Wed Jul 21 1999 - 12:34:07 CDT