I wrote this Procedure and I couldn't figers what is the problem can any one help me please:wacky: CREATE OR REPLACE PROCEDURE SelectProc IS DECLARE ID PRODUCT.Emp_NO%TYPE; Name PRODUCT.Full_Name%TYPE; BEGIN select Emp_NO,Full_Name into ID,Name from empTest; END SelectProc;
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 Code: 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; /