SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

how to take input from user in pl sql procedure ?

User_OMA69Feb 22 2022

I have two procedure in my .sql file ? When I login into Oracle database and execute the .sql file in command prompt ? It should ask the user which procedure it needs to execute ?
hello.sql file contains a function and two procedure with arguments,
A)create or replace procedure dbcheck(parallel_no_cnt in number default 4,p_table_name in varchar2 default null)
B)CREATE OR REPLACE PROCEDURE voccheck(parallel_no_cnt in number default 4,p_table_name in varchar2 default null).

How to take input from user for the above two procedure ?

Added on Feb 22 2022

#oracle, #pl-sql, #plsql, #sql, #sql-developer

11 comments

11,231 views

2 mentions