From: mcstockX@Xenquery   
      
   "Jim Kennedy"  wrote in message   
   news:LAndc.95053$gA5.1237341@attbi_s03...   
   |   
   | "DottingTheNet"  wrote in message   
   | news:11bf8d5a.0404081756.621895f0@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   
      
   --- SoupGate-Win32 v1.05   
    * Origin: you cannot sedate... all the things you hate (1:229/2)