PL/SQL Procedure Problem

[Quoted] Hi there, I'm new to PL/SQL and have been given the following procedure:

create or replace procedure otime (hoursworked number) as overtimehours number;
normalhours number;
message varchar2(30);
begin
normalhours := 35;
if hoursworked > normalhours then
overtimehours := hoursworked - normalhours; message := 'Overtime Hours worked = ';
dbms_output.put_line(message);
dbms_output.put_line(overtimehours);
else
message := 'No Overtime!';
dbms_output.put_line(message);
end if;
end;

but when I EXECUTE this, I get an error and I think it is referring to the [Quoted] [Quoted] datatype(number) after 'hoursworked' in the 1st line. Could someone give me [Quoted] some help on this please?

[Quoted] Also, how would I get the data from a column called hours in a table called [Quoted] EMP, when using a procedure?

Many thanks,
James Received on Wed Oct 15 2003 - 13:16:38 CEST