Can a SQL INSERT fail without raising an exception in PL/SQL

Are there any cases where an INSERT in SQL (specifically Oracle-PL/SQL) can fail without an exception being thrown? I'm seeing checks in code after INSERT where it verifies that SQL%ROWCOUNT = 1 ELSE it raises its own user-defined exception. I don't see how that can ever happen.

Answers


It can't fail without an exception, no. Probably the developer who wrote the code didn't know that.

An after statement trigger could conceivably delete the row just inserted. And of course an INSERT...SELECT might find no rows to insert, and so would result in SQL%ROWCOUNT = 0.


Need Your Help

.NET: What does Graphics.DrawImageUnscaled do?

.net winforms gdi+ system.drawing

It is not well known, that if you draw an image, e.g.:

c# Application Configuration File: AppSettings Reads Empty?

c# configuration

This is my first time using an XML config file. In the solution explorer I right click, add, new item, application config. file.

About UNIX Resources Network

Original, collect and organize Developers related documents, information and materials, contains jQuery, Html, CSS, MySQL, .NET, ASP.NET, SQL, objective-c, iPhone, Ruby on Rails, C, SQL Server, Ruby, Arrays, Regex, ASP.NET MVC, WPF, XML, Ajax, DataBase, and so on.