Re: PL/SQL equivalent of ACCEPT command?

Hi Donald.

When your're running your stored procedure you don't have any user interface attached -- you are running inside the database. You need to code the user interface in the tool you use to call the stored procedure (SQL*Plus, Forms, JDeveloper, Visual Basic etc).

HTH. Finn

--
---------------------------------------------------------------------------
 Finn Ellebaek Nielsen                           ChangeGroup ApS
 Product Manager, Principal Consultant, Partner  Kronprinsessegade 54, 4.
 E-mail: finn.ellebaek.nielsen_at_changegroup.dk    DK-1306  Koebenhavn K
 Mobile: +45 20 32 49 25                         Denmark
 Phone:  +45 33 32 77 78                         http://www.changegroup.dk
---------------------------------------------------------------------------
                      "Where do you want to GPF today?"
"Donald Mack" <donald.mack_at_sympatico.ca> wrote in message
news:QbAz9.1171$QD6.160373_at_news20.bellglobal.com...


> Hi,

>

> I'm wondering if there's an easy way to get interactive

> input from the user while executing a PL/SQL

> procedure. SQL*Plus has the ACCEPT command

> but is there something like a

> dbms_output.get_line that reads from the keyboard

> instead of the built-in buffer?

>

> Donald

>

>