Error in creating procedure Oracle SQL

Question

I want to create a procedure that deletes the employee with the greatest salary. I have this code:

create or replace procedure DelMostExpensive
as
begin
delete from hr.Employees where 
hr.Employees.EmpName=
(select EmpName from hr.Employees where 
salary = (select max(salary) from hr.Employees))
and hr.Employees.birthDate=
(select birthDate from hr.Employees where 
salary = (select max(salary) from hr.Employees));
end;

But I get these errors: Error(4,1): PL/SQL: SQL statement ignored. Error(4,16): PL/SQL: Ora-00942 table or view does not exist. How to make it work?

Just Rudy · Accepted Answer · 2016-11-23 15:21:43Z

1

Look at line 4:

delete from hr.Almalmazott2 where

Do you know what table you're trying to delete from? This looks like a table column.

answered Nov 23, 2016 at 15:21

Just Rudy

70012 silver badges31 bronze badges

Sign up to request clarification or add additional context in comments.

3 Comments

agiro Over a year ago

nope and sorry I forgot to translate. hr is a schema, hr.Employees is a table itself.

Just Rudy Over a year ago

Ok, are you able to desc fr.Employees ?

agiro Over a year ago

I am. I see the name, salary, job, whatnots.

Collectives™ on Stack Overflow

Error in creating procedure Oracle SQL

1 Answer 1

3 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

3 Comments

Your Answer

Sign up or log in

Post as a guest

Related