Re: user interaction in pl/sql

From: Mark C. Stock <mcstockX_at_Xenquery>
Date: Thu, 8 Apr 2004 22:17:09 -0400
Message-ID: <Zf6dnY-htJQxmuvd4p2dnA@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 Thu Apr 08 2004 - 21:17:09 CDT