Create Private db link in Oracle DB without login in user

 Create Private db link in Oracle DB without login in user

CREATE OR REPLACE PROCEDURE Schema.create_db_link IS
BEGIN
    EXECUTE IMMEDIATE q'[ 
        CREATE DATABASE LINK Link_Name 
        CONNECT TO USERNAME IDENTIFIED BY "PASSWORD" 
        USING 'tnsentry' 
    ]';
END;
/

begin
    Schema.create_db_link;

end;
/

drop procedure Schema.create_db_link;