Oracle Script For Menu

From: Arijit Chatterjee <arijitchatterjee123_at_yahoo.co.in>
Date: 10 Jun 2005 05:37:53 -0700
Message-ID: <1118407073.081373.27330@g44g2000cwa.googlegroups.com>

Hi All,
I am trying to write a script as a menu from SQLPLUS screen.

=====================Code

-------1. Activity1
-------2. Activity2

set echo off
ACCEPT VAL PROMPT 'ENTER CHOICE :'
if val=1 then

        execute Activity1
elsif val=2 then

        execute Activity2
end if

---

But can anyone put some lights to go for right direction.Because It is showing some error.If condition is not working.And I need to write a loop also. Please guide me.Thanks in advance. Regards
Arijit Chatterjee Received on Fri Jun 10 2005 - 07:37:53 CDT