ORA-06502: PL/SQL

From: <sikyala_at_comcast.net>
Date: 14 Dec 2004 07:08:56 -0800
Message-ID: <1103036936.008471.11730@c13g2000cwb.googlegroups.com>

I wrote the following script:

DECLARE type employee is record(
LAST_NAME VARCHAR2(15) ,
FIRST_NAME VARCHAR2(15) ,
HOURS_WORKED NUMBER(5,2) ,
HOURLY_RATE NUMBER(5,2) ,
TAX_DEDUCTION NUMBER(5,2)); SALARY NUMBER(7,2); tot_sal number(10,2);

type emp_array is varray(5) of employee;

emp emp_array := emp_array(null, null, null, null, null);

index1 number;
index2 number;
index3 number;
index4 number;
index5 number;

Begin

--enter data

emp(index1).last_name :='&last_name';
emp(index1).FIRST_NAME :='&FIRST_NAME';
emp(index1).HOURS_WORKED :=&HOURS_WORKED;
emp(index1).HOURLY_RATE :=&HOURLY_RATE;
emp(index1).TAX_DEDUCTION :=&TAX_DEDUCTION;

emp(index1).salary := (emp(index1).HOURS_WORKED * emp(index1).HOURLY_RATE) - emp(index1).

TAX_DEDUCTION;

emp(index2).last_name :='&last_name';
emp(index2).FIRST_NAME :='&FIRST_NAME';
emp(index2).HOURS_WORKED :=&HOURS_WORKED;
emp(index2).HOURLY_RATE :=&HOURLY_RATE;
emp(index2).TAX_DEDUCTION :=&TAX_DEDUCTION;

emp(index2).salary := (emp(index2).HOURS_WORKED * emp(index2).HOURLY_RATE) - emp(index2).

TAX_DEDUCTION;

emp(index3).last_name :='&last_name';
emp(index3).FIRST_NAME :='&FIRST_NAME';
emp(index3).HOURS_WORKED :=&HOURS_WORKED;
emp(index3).HOURLY_RATE :=&HOURLY_RATE;
emp(index3).TAX_DEDUCTION :=&TAX_DEDUCTION;

emp(index3).salary := (emp(index3).HOURS_WORKED * emp(index3).HOURLY_RATE) - emp(index3).

TAX_DEDUCTION;

emp(index4).last_name :='&last_name';
emp(index4).FIRST_NAME :='&FIRST_NAME';
emp(index4).HOURS_WORKED :=&HOURS_WORKED;
emp(index4).HOURLY_RATE :=&HOURLY_RATE;
emp(index4).TAX_DEDUCTION :=&TAX_DEDUCTION;

emp(index4).salary := (emp(index4).HOURS_WORKED * emp(index4).HOURLY_RATE) - emp(index4).

TAX_DEDUCTION;

emp(index5).last_name :='&last_name';
emp(index5).FIRST_NAME :='&FIRST_NAME';
emp(index5).HOURS_WORKED :=&HOURS_WORKED;
emp(index5).HOURLY_RATE :=&HOURLY_RATE;
emp(index5).TAX_DEDUCTION :=&TAX_DEDUCTION;

emp(index5).salary := (emp(index5).HOURS_WORKED * emp(index5).HOURLY_RATE) - emp(index5).

TAX_DEDUCTION; tot_sal := emp(index1).salary + emp(index2).salary + emp(index3).salary + emp(index4).salary

+ emp(index5).salary ;

/*dbms_output.put_line ('---------Employee Report----------');

dbms_output.put_line ('                                  ');

dbms_output.put_line
('Name----------Hours-------Rate-------Tax-----Salary');

dbms_output.put_line ('                                  ');*/

/*dbms_output.put_line (emp(index1).last_name ||emp(index1).FIRST_NAME
|| emp(index1).

HOURS_WORKED || emp(index1).HOURLY_RATE || emp(index1).TAX_DEDUCTION );*/
/*dbms_output.put_line (' ');

dbms_output.put_line ('________________________ Total______');
dbms_output.put_line ('________________________' || tot_sal);*/

end;

/

when I ran this script I receive the following error:ORA-06502: PL/SQL How do I fix this? Please help me someone.

Thanks! Received on Tue Dec 14 2004 - 09:08:56 CST