I just ran a rather simple INSERT statement (that I think processed a lot of rows), and I got the message:
-1,311,750,183 rows inserted
Should I be concerned about the fact that it's negative?
Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. It only takes a minute to sign up.Sign up to join this community
It is possible that the number of rows exceed the value of PLS_INTEGER. Here is the quote from Oracle on
%ROWCOUNTAttribute: How Many Rows Were Fetched?
%ROWCOUNTreturns: Zero after the explicit cursor is opened but before the first fetch Otherwise, the number of rows fetched (a
PLS_INTEGER) Note: If the number of rows exceeds the maximum value for a
SQL%ROWCOUNTreturns a negative value. For information about
PLS_INTEGER, see "PLS_INTEGER and BINARY_INTEGER Data Types".