PlSql help. Urgent Please.

From: Abhimanyu Parasher <aparashe_at_numbat.cs.rmit.edu.au>
Date: 25 Apr 1999 01:38:08 GMT
Message-ID: <7ftrm0$f8g$1@emu.cs.rmit.edu.au>

Thanks Manmohan Mann for helping me for my previous query. I've got one more question here, if anybody can help me with this ?

I'm creating a menu & writing following code for this : SET SERVEROUTPUT ON
DECLARE
    choice NUMBER(1);
BEGIN

  DBMS_output.put_line('*******************************************');
  DBMS_output.put_line('* 1) Amend Courses                        *');
  DBMS_output.put_line('* 2) Amend Subjects Info.                 *');
  DBMS_output.put_line('* 3) Amend Student Info.                  *');
  DBMS_output.put_line('* 4) Amend Student Enrolment Info.        *');
  DBMS_output.put_line('*******************************************');

  DBMS_output.put_line('&choice');
END;
/
The problem here is that it first ask the input & doesn't display the menu that I created before this. What should I do ?

Another one is that, after the code is executed on SQL Prompt, it shows me the operation that it performs e.g.:

            old 10:  DBMS_output.put_line('&choice');
            new  10:   DBMS_output.put_line('');

Can I stop this thing ?

Please help me. Its very urgent.

Thanks

Abhimanyu Parasher

--

Received on Sat Apr 24 1999 - 20:38:08 CDT