[kidas]

hi, you cannot have DECLARE in your create procedure statement. Also it's not a good idea to use ID, NAME for variables because they are oracle reserved keywords. Here's the corrected code, it will work

CREATE OR REPLACE PROCEDURE selectproc
AS
   l_ID        product.emp_no%TYPE;
   l_NAME   product.full_name%TYPE;
BEGIN
   SELECT emp_no, full_name
     INTO l_ID, l_NAME
     FROM emptest;
     
END selectproc;
/