Re: Commit in procedure

2005-06-01 Thread Flavio Silveira
How do I run without this isolation level (3)? I don't configure nothing about level and just run a procedure. - Original Message - From: "Anhaus, Thomas" <[EMAIL PROTECTED]> To: "Flavio Silveira" <[EMAIL PROTECTED]>; Sent: Wednesday, June 01

AW: Commit in procedure

2005-06-01 Thread Anhaus, Thomas
Flavio Silveira wrote : > >When I write a procedure, I have to explicity COMMIT or the >procedure do this automaticaly? I have a problem: I have a >cursor and, for each fetch, i insert some values in a table. >But the table "lock" every time. If I explicity a COMMIT, the >table unlock? > >Than

AW: Commit in procedure

2005-06-01 Thread Zabach, Elke
Flavio Silveira : > > When I write a procedure, I have to explicity COMMIT or the procedure do > this automaticaly? I have a problem: I have a cursor and, for each fetch, > i insert some values in a table. But the table "lock" every time. If I > explicity a COMMIT, the table unlock? > No dbproc

Commit in procedure

2005-05-31 Thread Flavio Silveira
When I write a procedure, I have to explicity COMMIT or the procedure do this automaticaly? I have a problem: I have a cursor and, for each fetch, i insert some values in a table. But the table "lock" every time. If I explicity a COMMIT, the table unlock? Thanks and sorry for the bad English :)