Re: user interaction in pl/sql

From: niranjan v sathe <satheniranjan_at_yahoo.com>
Date: 9 Apr 2004 10:15:28 -0700
Message-ID: <c3fae289.0404090915.3ac8e1c4@posting.google.com>

Hans Forbrich <forbrich_at_yahoo.net> wrote in message news:<pKndc.23709$J56.18035_at_edtnps89>...
> DottingTheNet wrote:
>
> > 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
>
> Counter-question - if the database is on a server, and the pl/sql is run in
> the database, where is the answer coming from?
>
> You might want to give some hint of the environment you are running. Are
> you displaying in a browser or in SQL Plus?

you can try with colon (:variablename) in pl-sql. This should prompt for a value. Received on Fri Apr 09 2004 - 12:15:28 CDT