Commit doesn't work [message #40856] |
Fri, 08 November 2002 00:56 |
venkatesh
Messages: 72 Registered: August 2000
|
Member |
|
|
hi all,
i use this kind of pl/sql in my application.
begin
for i in 1.100 loop
insert into t
values (seq.nextval, i);
end loop;
commit;
end;
when i execute this, the transaction is not getting committed... i have to explicitly commit the transaction. only then it is getting affected in the application. wht could be the possible reason for this?
thanx in advance
regs.
venkatesh
|
|
|
Re: Commit doesn't work [message #40859 is a reply to message #40856] |
Fri, 08 November 2002 03:52 |
Giridhar
Messages: 38 Registered: May 2001
|
Member |
|
|
i have copied ur code and tested it.Only modification you have to do is to add another (.) in the for loop
Use
for i in 1 .. 100 loop
instead of
for i in 1.100 loop
if you tested with the same piece of code,you too might have got the error.
Giridhar
|
|
|