Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Re: prompting user for a value in PL/SQL procedure

Re: prompting user for a value in PL/SQL procedure

From: Michel Cadot <micadot_at_netcourrier.com>
Date: Wed, 5 Apr 2000 15:47:20 +0200
Message-ID: <8cfg5l$1tkm$1@news4.isdnet.net>


You can't prompt the user in a procedure.

Instead you can prompt it with ACCEPT before the call of the procedure and then call the procedure with the returned value as a parameter.

--
Have a nice day
Michel

Chul Kim <kimc_at_ugsolutions.com> a écrit dans le message : 38eb39ab$1_at_usenet.ugsolutions.com...
> Is there a way to prompt the user who is executing a procedure for a value?
> ACCEPT doesn't seem to work.
>
> Thank you.
>
>
Received on Wed Apr 05 2000 - 08:47:20 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US