Create Procedure, DBLink in Oracle

PROCEDURE
CREATE OR REPLACE procedure PROCEDURE_NAME as
begin
*Script yang akan di eksekusi.*   
    commit;
end;
/

 DBLINK
CREATE DATABASE LINK DBSMILE
 CONNECT TO user
 IDENTIFIED BY <pwd>
 USING '(DESCRIPTION= (ADDRESS= (PROTOCOL=TCP) (HOST=scan-colodb.telkom.co.id) (PORT=1521) ) (CONNECT_DATA= (SERVICE_NAME=colodb) ) )';