Re: user interaction in pl/sql
Date: Thu, 8 Apr 2004 22:17:09 -0400
Message-ID: <Zf6dnY-htJQxmuvd4p2dnA_at_comcast.com>
"Jim Kennedy" <kennedy-downwithspammersfamily_at_attbi.net> wrote in message
news:LAndc.95053$gA5.1237341_at_attbi_s03...
|
| "DottingTheNet" <dottingthenet_at_hotmail.com> wrote in message
| news:11bf8d5a.0404081756.621895f0_at_posting.google.com...
| > hi!!
| > just wanna know how to accept user input??
| > if i prompt a question "Are u happy today?(Y/N)"
| > how do i receive user's answer?
| > thnx
| You can do this in sqlPlus but not in pl/sql.
| Jim
|
|
pl/sql is run in the database (unless you're using oracle's Form or Report Builder tools to developer GUI apps)
so, there is no communication with the client tool while PL/SQL is running, hence no prompting
what is your development environment?
;-{ mcs Received on Fri Apr 09 2004 - 04:17:09 CEST