Skip to Main Content
Forums

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!

Interested in getting your voice heard by members of the Developer Marketing team at Oracle? Check out this post for AppDev or this post for AI focus group information.

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 ?

Comments

Processing

Post Details

Added on Feb 22 2022
#oracle, #pl-sql, #plsql, #sql, #sql-developer
11 comments
10,716 views
2 mentions