Re: Help : problem with using Rollback segment in Oracle Form

I'd issue a Standard.Commit; or Commit_form; prior to the Dbms_transaction call, and then verify that you have in fact, grabbed that rollback segment, which you can check via db views. I did something very similar with some batch runs and big SQL*Plus update scripts and I always started them with a ROLLBACK statement or a COMMIT prior to the dbms_transaction call. The call has to be the first statement of a NEW transaction, and sometimes it gets "overlooked".
Good luck.

"Pearapon Saerekul" <pearapon_at_ksc.th.com> wrote in message news:8mldee$g5u$1_at_news.ksc.co.th...
> Dear All,
> Recently, I havesome problems about assigning "Rollback Segment" in
> Oracle From. I have to write Orcle application usinf Oracle Form that have
> to update data about 900,000 records.
> I have specified using of Rollback Segemnt in "Pre Form" section of Oracle
> Form as the following:
>
> BEGIN
> DBMS_TRANSACTION.USE_ROLLBACK_SEGMENT('bigvol');
> exception
> when others then
> null ;
> END;
>
> However, when I ran this program to update for about 45,000 records. I
> got the error :
> " ERROR R03 TOO SMALL". According to this error message, it seems that my
> program did not use "bigvol" rollback segment at all. Are there any other
> places that I have to specify the program to use "bigvol" rollback
 segement,
> which I think it is large enough to handle for updating 900,000 records I
> use Oracle Form Designer V.4.5.6.5.5 to access Oracle DB V.7.3.3 on SUn
> Solarlis.
> Please help. I need a solution badly. Thank you very much in advance.
> Regards,
>
> --
> Pearapon Saerekul
> ( pearapon_at_ksc.th.com )
>
>
>
Received on Sat Aug 12 2000 - 00:00:00 CEST