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

From: Jaap W. van Dijk <j.w.vandijk.removethis_at_hetnet.nl>
Date: Sun, 10 Mar 2002 07:19:11 GMT
Message-ID: <3c8b083a.897090@news.freeler.nl>

If you are at the UNIX prompt:

Write a script that
- starts your package in a background sqlplus session - starts a foreground sqlplus session that communicates with the package via DBMS_PIPE.

How's that?

Jaap.

On 8 Mar 2002 06:06:43 -0800, rkg100_at_erols.com (Ryan Gaffuri) wrote:

>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?
Received on Sun Mar 10 2002 - 01:19:11 CST