PL/SQL (MOSC)

MOSC Banner

Accepting an Input when running a PL/SQL procedure

in PL/SQL (MOSC) 1 commentAnswered

OS - RHEL 7.9

DB version - 19.18

I am running the dbms_datapump executable within a procedure to copy schemas. I created the procedure and then I am calling it with the inputs.

Question/Suggestions - I would like to be prompted for input (source and destination users) when calling the procedure.


-----------Procedure Start------------------

CREATE OR REPLACE PROCEDURE mrw_copy_schema 

(

 in_srce_user  IN VARCHAR2,

 in_dest_user  IN VARCHAR2,

 in_dest_user_pswd IN VARCHAR2,

 in_paral_lvl  IN NUMBER DEFAULT 4,

 in_netwk_link  IN VARCHAR2 DEFAULT 'MRW_LINK',

 in_incld_rows  IN NUMBER DEFAULT 1 

AUTHID CURRENT_USER

AS

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center