Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations SkipVought on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Cursor problem

Status
Not open for further replies.
joereena

joereena

Programmer
Apr 18, 2001
8
0
0
IN
one query : if a program calling db procedure losses connection with the database, then what will happen to the cursors not closed in the db procedure. Will there be any problem due to open cursors on the server?

Please help .
 
Sort by date Sort by votes
in theory, SMON process tidies up after failed sessions, while it is not foolproof it does clean up as best it can. I tried to remain child-like, all I acheived was childish.
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

johnherman
  • Locked
  • Question
cursor with dynamic SQL
Replies
1
Views
37
carp
carp
juniorplsql
  • Locked
  • Question
cursor for loops to insert record into a table
Replies
10
Views
366
juniorplsql
juniorplsql
dabiri
  • Locked
  • Question
Problem connecting to oracle 10g database.
Replies
18
Views
149
dabiri
dabiri
murphyhg
  • Locked
  • Question
Error in code with cursor
Replies
1
Views
48
carp
carp
rivi10
  • Locked
  • Question
raise exception within an insert cursor loop
Replies
4
Views
38
SantaMufasa
SantaMufasa

Part and Inventory Search

Sponsor

Back
Top