Procedure to ask number of rows to insert

Can I write a procedure which asks a user the number of rows to insert and can take the input in a commit?

    Requires Free Membership to View

You cannot create a procedure that accepts prompts from users. You can create a SQL script to accept prompts when using SQL*Plus. You would use the "Prompt" and "Accept" commands.

This was first published in July 2006

Join the conversationComment

Share
Comments

    Results

    Contribute to the conversation

    All fields are required. Comments will appear at the bottom of the article.