CODE EXAMPLE FOR SQL

oracle execute package dblink

BEGIN
    my_scheme.my_package.my_procedure@my_dblink('parameter1', 'parameter2');
END;