| Does Commit Close the Implicit Cursor? [message #492947] |
Thu, 03 February 2011 19:20  |
 |
atgramesh
Messages: 23
Registered: January 2011
|
Junior Member |
|
|
Hi,
We all know that commit will do the following.
1. Save the Txn Permanently to the database.
2. Release the table locks and
3. Erase the save points.
TABLE NAME:
==========
create table TEST_PREC (NO NUMBER(4,2));
DECLARE
BEGIN
INSERT INTO TEST_PREC VALUES (12.34);
DBMS_OUTPUT.PUT_LINE('the no of records before commit '||SQL%ROWCOUNT);
commit; /* What's happening inside commit */
DBMS_OUTPUT.PUT_LINE('the no of records after commit '||SQL%ROWCOUNT);
END;
SQL> /
the no of records before commit 1
the no of records after commit 0
My question is why the SQL%ROWCOUNT is set to zero
after commit.
Does the commit, close the implicit cursor?
Thanks and Regards,
Ramesh V
|
|
|
|
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
