Re: PL/SQL Question

Accept is a sql*plus command, it's not a sql command nor a pl/sql command. I say this just because it's important to differentiate between sql*plus, sql and pl/sql, many people run into problems because they don't know the difference.
That said, there is a dbms_output.get_line procedure, but the only thing I know it's cumbersome to use.
If your pl/sql block is an anonymous block, you should know you can use (there I go again) sql*plus substitution variables/defines in your block. So you can use an accept *prior* to starting your pl/sql block and use &<variablename> inside your code.

Hth,
Sybrand Bakker, Oracle DBA

<glandry860_at_my-deja.com> wrote in message news:8jvkth$ckk$1_at_nnrp1.deja.com...
> Greetings,
>
> I am a PL/SQL newbie and have a question that I have
> not been able to find the answer to in my manuals and
> class notes. It is this:
>
> How does one prompt for user input from within a PL Block?
>
> ACCEPT doesn't appear to work from within the block!
>
> Thanks in advance!
>
> Greg Landry
>
>
> Sent via Deja.com http://www.deja.com/
> Before you buy.
Received on Wed Jul 05 2000 - 00:00:00 CDT