PL/SQL (MOSC)

MOSC Banner

11gR2 : Explicit cursor executed(OPEN) but still displayed at session-level ?

edited Jan 9, 2014 4:54AM in PL/SQL (MOSC) 7 commentsAnswered
Hi ,

My explicit cursor allows me to perform un update for each row.

Why the select of the cursor remains at session level even when cursor fetch is beginnig ?

Normally , when update appears in my session , this prouves that execution  of the cursor is finished (OPEN cursor is OK) and fetch in progress ?

Best regards.

GD.




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