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: Keyboard Input in a Procedure

Re: Keyboard Input in a Procedure

From: Jonathan Gennick <jonathan_at_gennick.com>
Date: Wed, 14 Apr 1999 04:19:05 GMT
Message-ID: <37160df5.15323558@netnews.worldnet.att.net>


On Tue, 13 Apr 1999 17:49:11 -0500, "Dan Metzger" <dametzge_at_plains.nodak.edu> wrote:

>Using PL/SQL, how can I get keyboard input inside of a procedure (assume in
>VARCHAR2 format) ????

Do you mean from a database stored procedure? If so, then you can't prompt the user for input. If you are running something from SQL*Plus, then you could have SQL*Plus prompt for input, and then pass that on to the procedure.

Jonathan Received on Tue Apr 13 1999 - 23:19:05 CDT

Original text of this message

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