Re: PlSql help. Urgent Please.

For your second pbm you can try one of this set verify off, set echo off, set feedback off (i don't remember)

Abhimanyu Parasher wrote:

> 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 Thu May 20 1999 - 08:20:40 CDT