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

Home -> Community -> Usenet -> c.d.o.server -> Re: Is it possible to accept input from a user in PL/SQL

Re: Is it possible to accept input from a user in PL/SQL

From: Thomas Kyte <tkyte_at_oracle.com>
Date: 8 Mar 2002 12:00:52 -0800
Message-ID: <a6b59k030ti@drn.newsguy.com>


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 Corp 
Received on Fri Mar 08 2002 - 14:00:52 CST

Original text of this message

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