Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Is it possible to accept input from a user in PL/SQL
In article <6757365f.0203080606.5b10373_at_posting.google.com>, rkg100_at_erols.com
says...
>
>I know you can use the SQLPLUS ACCEPT command to input data into a
>substitution variable and pass that to PL/SQL.
>
>However, is it possible to use PL/SQL to prompt the user for input and
>then use that input in PL/SQL?
Not if the plsql is running in the database -- that plsql can do no UI.
If the plsql is running in a form ala Oracle Forms -- then yes it could.
-- Thomas Kyte (tkyte@us.oracle.com) http://asktom.oracle.com/ Expert one on one Oracle, programming techniques and solutions for Oracle. http://www.amazon.com/exec/obidos/ASIN/1861004826/ Opinions are mine and do not necessarily reflect those of Oracle CorpReceived on Fri Mar 08 2002 - 14:00:52 CST