Re: PL/SQL get user input ???

Hi Scott,

PL/SQL uses accept command. Full syntax is:

ACCEPT variable [NUMBER|CHAR] PROMPT text NOPROMPT HIDE

In SQL*Plus:

accept variable_name prompt 'Enter a value : '

If you need to hide input from users, add HIDE clause

accept password prompt 'Enter password : ' hide

Glad to meet friends from same organization ! Feel free to contact me if you need more details.

Best regards

Breno Gomes

scott.daniels_at_ieee.org wrote:

> Can anyone give me a hint on how to get user input using a
> PL/SQL program under Oracle 8 ?
> I tried dbms_output.get_LINE(...) BUT THE PROGRAM JUST SKIPS
> past that line of code and never pauses for my input.
> Oracles;s on-line docs haven't been much help, as they
> don;t show any examples, and don't tell me how to read
> from stdin, eg.
>
> Any help would be greatly appreciated.
> Please copy reply to me at:
> scott.daniels_at_ieee.org
>
> Thanks in advance
> Scott
>
> Sent via Deja.com http://www.deja.com/
> Share what you know. Learn what you don't.

--
"A little push in the right direction can make a big difference"

My ICQ# is 35567342
Visit http://www.mirabilis.com/

Received on Mon Jun 21 1999 - 18:46:06 CDT