Bryan, Miriam wrote:
CREATE OR REPLACE PROCEDURE EMPLOYEE_ACTIVITY.convert_AA_admin
FOR x IN get_workgroups
LOOP
begin
if upper(x.level_) in ('CENTER','TEAM','GROUP') then
v_security_group := 4;
else if upper(x.level_) in ('PAYROLL') then
^^^^^^^
else if or elsif?
PL/SQL User's Guide and Reference Release 2 (9.2)
4 PL/SQL Control Structures
Conditional Control: IF and CASE Statements
IF-THEN-ELSIF Statement
BTW, it's a very good habit to provide as more information
as you have to the list. Oracle edition, platform, exact
error message etc. -- there are very few clairvoyants and
telepaths in this list, some of them have vacations now...
Regards,
--
Vladimir Begun
The statements and opinions expressed here are my own and
do not necessarily represent those of Oracle Corporation.
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Vladimir Begun
INET: [EMAIL PROTECTED]
Fat City Network Services -- 858-538-5051 http://www.fatcity.com
San Diego, California -- Mailing list and web hosting services
---------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from). You may
also send the HELP command for other information (like subscribing).
