Tuesday 3 September 2013

How to execute package or procedure using DB link in Oracle



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