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

[Quoted] The 'when others then null;' - clause prevents you from seeing error [Quoted] messages. Remove it, and hopefully you will get a more meaningful message.

Marc

[Quoted] Pearapon Saerekul wrote in message <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 Mon Aug 07 2000 - 00:00:00 CEST