One way you could do it is to ACCEPT all variables
before calling the SP, and the pass the accepted
values when calling the SP.
- Arun Annamalai <oracle_at_shakaboom.com> wrote:
> You can use dbms_alerts and dbms_pipe message to
> read from pl/sql block.
>
> (Its been while I have done this)
>
> -Arun.
> ----- Original Message -----
> To: "Multiple recipients of list ORACLE-L"
> <ORACLE-L_at_fatcity.com>
> Sent: Monday, May 12, 2003 12:27 PM
>
>
> >
> > You will need to do any user interaction from
> > within SQLPLUS, then use the results in your
> > PL/SQL block.
> >
> > Jared
> >
> > On Monday 12 May 2003 09:17, Kader Ben wrote:
> > > Hi Listers,
> > >
> > > I'm about writing a code to prompt user to enter
> some
> > > data and the code do some verification and
> > > subsequently prompt him for further information.
> > > Basically the pseudocode looks like the
> following:
> > >
> > >
> > > define a = Y ;
> > > define b = N;
> > > define c = 10;
> > > accept a prompt 'Enter value of a: ';
> > >
> > > BEGIN
> > > IF('&&a' = 'Y')
> > > THEN
> > > DBMS_OUTPUT.PUT_LINE('Enter value of c :');
> > > ACCEPT c;
> > > IF &&c = 10 THEN
> > > -- do some staff
> > > END IF;
> > > ELSIF('&&a' = 'N')
> > > THEN
> > > -- do other treatment
> > > END IF;
> > > END;
> > > /
> > >
> > >
> > > The problem the ACCEPT nor PROMPT doesn't work
> inside
> > > the
> > > PL/SQL code. Do you have any suggestion to do
> the code
> > > interact with user?
> > >
> > > Thank you in advance.
> > >
> > >
> > > Ben
> > >
> > >
> > >
> > > __________________________________
> > > Do you Yahoo!?
> > > The New Yahoo! Search - Faster. Easier. Bingo.
> > > http://search.yahoo.com
> > --
> > Please see the official ORACLE-L FAQ:
> http://www.orafaq.net
> > --
> > Author: Jared Still
> > INET: jkstill_at_cybcon.com
> >
> > Fat City Network Services -- 858-538-5051
> http://www.fatcity.com
> > San Diego, California -- Mailing list and
> web hosting services
> >
>
> > To REMOVE yourself from this mailing list, send an
> E-Mail message
> > to: ListGuru_at_fatcity.com (note EXACT spelling of
> 'ListGuru') and in
> > the message BODY, include a line containing: UNSUB
> ORACLE-L
> > (or the name of mailing list you want to be
> removed from). You may
> > also send the HELP command for other information
> (like subscribing).
> >
> >
> >
>
> --
> Please see the official ORACLE-L FAQ:
> http://www.orafaq.net
> --
> Author: Arun Annamalai
> INET: oracle_at_shakaboom.com
>
> Fat City Network Services -- 858-538-5051
> http://www.fatcity.com
> San Diego, California -- Mailing list and web
> hosting services
>
> To REMOVE yourself from this mailing list, send an
> E-Mail message
> to: ListGuru_at_fatcity.com (note EXACT spelling of
> 'ListGuru') and in
> the message BODY, include a line containing: UNSUB
> ORACLE-L
> (or the name of mailing list you want to be removed
> from). You may
> also send the HELP command for other information
> (like subscribing).
>
Do you Yahoo!?
The New Yahoo! Search - Faster. Easier. Bingo.
http://search.yahoo.com
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Deepak Sharma
INET: sharmakdeep_at_yahoo.com
Fat City Network Services -- 858-538-5051 http://www.fatcity.com
San Diego, California -- Mailing list and web hosting services
---------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from). You may
also send the HELP command for other information (like subscribing).
Received on Tue May 13 2003 - 11:22:33 CDT
