Home » RDBMS Server » Server Administration » fetch procedure of one database from another database server (Oracle 10g R2)
fetch procedure of one database from another database server [message #528150] Sat, 22 October 2011 04:23 Go to next message
dkdms2124
Messages: 369
Registered: April 2010
Location: INDIA
Senior Member

Hi All,

I want to know if I can access a procedure created on Database server A from database server B. Is it possible with the help of DBLink if not then what else method I can adopt.

Thanks
Deepak
Re: fetch procedure of one database from another database server [message #528151 is a reply to message #528150] Sat, 22 October 2011 04:33 Go to previous messageGo to next message
John Watson
Messages: 8960
Registered: January 2010
Location: Global Village
Senior Member
Why don't you just try it?

drcp> conn jon/jon@orcl
Connected.
orcl> create procedure p1 as begin
  2  null;
  3  end;
  4  /

Procedure created.

orcl> conn jon/jon@drcp
Connected.
drcp> create database link l1 using 'orcl';

Database link created.

drcp> exec p1@l1;

PL/SQL procedure successfully completed.

drcp>
Re: fetch procedure of one database from another database server [message #528153 is a reply to message #528151] Sat, 22 October 2011 04:43 Go to previous message
dkdms2124
Messages: 369
Registered: April 2010
Location: INDIA
Senior Member

Thanks Sir, i'll see if this solve my problem.

Regards
Deepak
Previous Topic: adrci issue
Next Topic: control file block size - db_block size?
Goto Forum:
  


Current Time: Fri Nov 29 04:26:28 CST 2024