Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.server -> Re: How to program PL/SQL receive input from screen?
ppakorn wrote:
>
>
> Dear everyone
>
> I'm a beginning user of PL/SQL language. Can anyone tell me how can I
> get input from screen? My program needs to ask some information like
> this
>
> Enter your account number:
> Enter your password:
> .
> .
> .
>
> I don't know the commands to take the inputs (the account number and
> password) from screen. I found only the way to show text on screen
> (dbms_output package), but couldn't find the way to receive input.
> Please help me.
>
>
>
> Thank you
> Pak
>
>
> Sent via Deja.com http://www.deja.com/
> Before you buy.
PL/SQL wasn't really meant to take inout from standard input. If you want
to read input from SQLPLUS use the & or && before a variable name. If you
really need to capture information so you can do things like logon to the
database you should probably think about using Pro C or one of the other 3
GLs or possibly a 4 GL like Forms or Powerbuilder depending on the problem
you are trying to solve
HTH
--
Posted via CNET Help.com
http://www.help.com/
Received on Tue Dec 28 1999 - 21:30:34 CST
![]() |
![]() |