Re: PL/SQL Stored Procedure Question
From: Robert M. Verlander <robv_at_accessone.com>
Date: 1996/01/21
Message-ID: <3102C590.6A9E_at_accessone.com>#1/1
> The following create procedure is not working.
>
> SQL> create procedure shwemp (emp_id number) is
> 2 begin
> 3 select empno, ename from emp where empno = emp_id;
> 4 end;
> 5 /
>
> Warning: Procedure created with compilation errors.
Date: 1996/01/21
Message-ID: <3102C590.6A9E_at_accessone.com>#1/1
leangl_at_ohsu.edu wrote:
>
> Have anyone encountered the following problem:
>...
> The following create procedure is not working.
>
> SQL> create procedure shwemp (emp_id number) is
> 2 begin
> 3 select empno, ename from emp where empno = emp_id;
> 4 end;
> 5 /
>
> Warning: Procedure created with compilation errors.
--
Lyny,
Your error appears to be that you aren't selecting into a variable (which
is one of the few ways you can use a select in PL/SQL.
When you encounter problems such as this the best thing to do is to type
the command:
SHOW ERRORS;
at the sql*plus prompt following the error warning for the package or
function.
Good Luck,
Rob Verlander
---------------------------------------------------------------------------------
E-Mail: robv_at_accessone.com Phone: 206-631-7702 Office:
206-281-4440
---------------------------------------------------------------------------------
Received on Sun Jan 21 1996 - 00:00:00 CET