Problem with Pl/SQL VMS 7.1-1H2 Oracle 7.3.2.3.2

Can anyone tell me if the following will compile OK ?

create or replace procedure colin1

is

        v_sector             sector.sector%type;
        v_sector_description sector.sector_description%type;

        cursor c1 is
               select sector,sector_description from sector;

begin

     for c1_rec in c1
     loop

     v_sector             := c1_rec.sector;
     v_sector_description := c1_rec.sector_description;

     dbms_output.put_line (v_sector);
     dbms_output.put_line (v_sector_description);

     end loop;

end colin1;

SQL> desc sector

 Name                            Null?    Type
 ------------------------------- -------- ----
 SECTOR                                   CHAR(3)
 SECTOR_DESCRIPTION                       VARCHAR2(60)

Giving some wierd errors to do with table access (procedure compiled from table owner schema)

--
Click here to e-mail me mailto:ian.downham_at_which.net Received on Wed Mar 03 1999 - 13:15:36 CST