0 Replies Latest reply: Dec 4, 2005 2:01 PM by 474093 RSS

    Prompt User and Insert to a new record

    474093
      Using PL/SQL with SQL Plus, how do I set up a loop, prompt the user for a value and then insert that info for as many times as the user wants to make records?

      I have 3 fields. first name, last name, address
      I set up the needed variables and the needed %rowtype variables.
      I set up a loop to prompt the user.
      the variables receive the input the first time successfully.
      then after the last variable is input
      I get an error: the Begin is unexpected and then it all fails for me.
      Also, how do I set up a user input that tells my logic that the user is done.
      Thanks, Virgil