Re: procedure error

From: L120bj <l120bj_at_aol.com>
Date: 1997/02/25
Message-ID: <19970225191400.OAA28409@ladder02.news.aol.com>#1/1

The call should be

 exec emp_info( 'FORD' )

Rob

---

---

Subject: procedure error
From: memphisrs_at_aol.com (Memphis rs)
Date: 25 Feb 1997 13:47:22 GMT
Message-ID: <19970225134701.IAA11630_at_ladder02.news.aol.com>

Does anyone know why I am getting a error when executing the following:

create or replace                                                         
     
procedure emp_info (person in varchar2)                                   
     
  is                                                                      
     
BEGIN for c1 in                                                           
     
  (select ename                                                           
     
    from emp                                                              
     
      where ename = person)                                               
     
  loop                                                                    
     
dbms_output.put_line(c1.ename);                                           
     
end loop;                                                                 
     
end;                                                                      
     

/

---

Here is the error

---

SQL> exec emp_info FORD                                                   
     
begin emp_info FORD; end;                                                 
     
                                                                          
     
               *                                                          
     
ERROR at line 1:                                                          
     
ORA-06550: line 1, column 16:                                             
     
PLS-00103: Encountered the symbol "FORD" when
           expecting one of the following:   
           := . ( @ % ;                                                   
                

The symbol ":=" was substituted for "FORD" to continue.

Any help will be appreciated
Richard Slochowsky
Entergy Integrated Solutions, Inc.
rslochow_at_esasi.com
Richard Slochowsky
Entergy Integrated Solutions, Inc. Received on Tue Feb 25 1997 - 00:00:00 CST