Go4Expert

Go4Expert (http://www.go4expert.com/)
-   Oracle (http://www.go4expert.com/forums/oracle-forum/)
-   -   Help with Orcal Stored Procedure (http://www.go4expert.com/forums/help-orcal-stored-procedure-t16378/)

waleed 1Mar2009 13:56

Help with Orcal Stored Procedure
 
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;

shabbir 1Mar2009 18:40

Re: Help with Orcal Stored Procedure
 
Nor we can figure out unless you try to explain what you are trying to do.

kidas 1Mar2009 18:55

Re: Help with Orcal Stored Procedure
 
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;
/



All times are GMT +5.5. The time now is 08:05.