 <p>If you are using some UI Terminal like SQLDeveloper or TOAD, you can achieve it using below code:</p> <pre><code>CREATE OR REPLACE INPUTPROCEDURE (LV_CHOICE IN VARCHAR2) AS BEGIN DBMS_OUTPUT.PUT_LINE('Enter Y to display Unauthorized records OR N to skip the display'); --SELECT &amp;1 INTO lv_choice FROM DUAL; IF lv_choice &lt;&gt; 'Y' THEN DBMS_OUTPUT.PUT_LINE ('RECORDS WILL NOT BE DISPLAYED'); ELSE DBMS_OUTPUT.PUT_LINE ('RECORDS TO BE DISPLAYED ARE:'); END INPUTPROCEDURE; </code></pre> <p>And Invoke the above Procedure like below:</p> <pre><code>DECLARE dyn_stmt VARCHAR2(200); b BOOLEAN := TRUE; BEGIN dyn_stmt := 'BEGIN INPUTPROCEDURE(:LV_CHOICE); END;'; EXECUTE IMMEDIATE dyn_stmt USING b; END; </code></pre>