To execute package or procure using DB link in Oracle database first create DB link .
To create DB link please view following link.
How to create DB link
Now you can call package or procedure using db link as follows.
Syntex:
exec schema.porcedure@db_link( {parameteres });
exec schema.package.procedure@db_link ([parameters});
Example:
exec ali_db.calculate_tax@raza_db (10000);
exec ali_db.tax_package.calculate_tax@raza_db (10000);
No comments:
Post a Comment