Re: user interaction in pl/sql

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 - 19:15:28 CEST