PL/SQL (MOSC)

MOSC Banner

Abnormal behavior of SQL%ROWCOUNT

edited Nov 13, 2009 8:51AM in PL/SQL (MOSC) 11 commentsAnswered
In a function I have used SQL%ROWCOUNT after INSERT statement to ensure how many rows inserted but some time it works and some time  it don’t . I have wrote 2 INSERT statement one after another and used SQL%ROWCOUNT after 2 nd INSERT to ensure row inserted into 2 nd INSERT statement. But some time I only found row in only 1 st INSERT. Please guide.

 

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center