Re: PlSql help. Urgent Please.

From: <dekates_at_my-dejanews.com>
Date: Fri, 21 May 1999 13:46:10 GMT
Message-ID: <7i3o31$qek$1@nnrp1.deja.com>

The reason why your menu does not work successfully is because a PL/SQL block is compiled first and then executed. Values for any bind parameter have to be provided at the time of compilation itself as any compiled PL/SQL block cannot have bind parameter (It is a SQL*Plus feature). Also, PL/SQL is not meant for interactive programming. One possible solution would be store a SQL script file containing the following :-

set feedback off
prompt '1. Amend Courses'
prompt '2. '

.
.
.

accept choice

In article <37440C28.B8D28D5C_at_india.hp.com>,   "G.H VITTAL" <vittal_at_india.hp.com> wrote:
> 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
> >
> > --
> >
> >
> >
>
>

--== Sent via Deja.com http://www.deja.com/ ==-- ---Share what you know. Learn what you don't.--- Received on Fri May 21 1999 - 08:46:10 CDT