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?
asked Jul 11, 2013 at 20:59
-
1Which DBMS are you using?– ypercubeᵀᴹCommented Jul 11, 2013 at 21:02
-
1I smell 32-bit DB software.– RolandoMySQLDBACommented Jul 11, 2013 at 21:10
-
SQL Developer. How can I check if I'm using 32 or 64 bit?– random_forest_fanaticCommented Jul 12, 2013 at 10:58
-
SELECT * FROM V$VERSION– msi77Commented Jul 12, 2013 at 16:06
-
Nope, it's 64 bit: Oracle Database 11g Enterprise Edition Release 11.2.0.2.0 - 64bit Production PL/SQL Release 11.2.0.2.0 - Production "CORE 11.2.0.2.0 Production" TNS for Linux: Version 11.2.0.2.0 - Production NLSRTL Version 11.2.0.2.0 - Production– random_forest_fanaticCommented Jul 14, 2013 at 11:43
Add a comment
|
1 Answer
It is possible that the number of rows exceed the value of PLS_INTEGER. Here is the quote from Oracle on %ROWCOUNT.
%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 (aPLS_INTEGER) Note: If the number of rows exceeds the maximum value for aPLS_INTEGER, thenSQL%ROWCOUNTreturns a negative value. For information aboutPLS_INTEGER, see "PLS_INTEGER and BINARY_INTEGER Data Types".
answered Jul 23, 2013 at 21:31
