pl/sql problem

From: Mark Wagner <mark_at_cybertrails.com>
Date: Mon, 12 Jul 1999 11:40:53 -0700
Message-ID: <HQqi3.40$M84.792305680@mick.cybertrails.com>

Im trying to run this pl/sql script and getting the following error......

SQL> @test2
DECLARE
*
ERROR at line 1:

ORA-01562: failed to extend rollback segment number 2
ORA-01650: unable to extend rollback segment R01 by 64 in tablespace RBS
ORA-06512: at line 21

here is my pl/sql script.................................

declare
 namel varchar2(30);
 namef varchar2(30);
 idcustomer varchar2(40);
 numacct varchar2(20);
 cursor test_cursor is
  select ispCustomer.LastName as LastName, ispCustomer.FirstName as FirstName, ispCustomer.CustomerID as CustomerID, ispbilling.bankaccountnumber as acctnum   where ispbilling.customerkey = ispcustomer.customerkey;  test_val test_cursor%ROWTYPE;
begin
 open test_cursor;
 loop
  fetch test_cursor into test_val;
  exit when test_cursor%NOTFOUND;
  namel := test_val.LastName;
  namef := test_val.FirstName;
  idcustomer := test_val.CustomerID;
  numacct := test_val.acctnum;
  dbms_output.put_line('this is the last name '||TO_CHAR(namel));   update deductees
  set LASTNAME = (select ispcustomer.LastName

     from ispcustomer, ispbilling
     where  ispbilling.bankaccountnumber = numacct AND
       ispbilling.customerkey = ispcustomer.customerkey),
  FIRSTNAME = (select ispcustomer.FirstName
     from ispcustomer, ispbilling
     where  ispbilling.bankaccountnumber = numacct AND
       ispbilling.customerkey = ispcustomer.customerkey),
  CUSTOMERID = (select ispcustomer.CustomerID
     from ispcustomer, ispbilling
     where  ispbilling.bankaccountnumber = numacct AND
       ispbilling.customerkey = ispcustomer.customerkey);

 end loop;
 close test_cursor;
end;
.
/ Received on Mon Jul 12 1999 - 13:40:53 CDT