Re: Newbie PL/SQL question

I can't make it work...
I get errors on the keyword ACCEPT, and in the SELECT DECODE line. Thanks for the help.

DECLARE
 choice NUMBER;
BEGIN  PROMPT Select an Action from following ugly menu:  ACCEPT choice PROMPT 'Action1 (1 default), Action2 (2), Action3 (3)' default 1

 col action_script new_val action_script noprint  SELECT DECODE(&&choice, 1, 'action1.sql', 2, 'action2.sql', 3, 'action3.sql', 'noaction.sql')

         action_script FROM dual;

 @&&action_script
END;
/ Received on Tue Jan 30 2001 - 08:07:23 CST