OraFAQ Forum: Server Administration » fetch procedure of one database from another database server

Home » RDBMS Server » Server Administration » fetch procedure of one database from another database server (Oracle 10g R2)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

fetch procedure of one database from another database server [message #528150]

Sat, 22 October 2011 04:23

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

Report message to a moderator

Re: fetch procedure of one database from another database server [message #528151 is a reply to message #528150]

Sat, 22 October 2011 04:33

John Watson
Messages: 8929
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>

Report message to a moderator

Re: fetch procedure of one database from another database server [message #528153 is a reply to message #528151]

Sat, 22 October 2011 04:43

dkdms2124
Messages: 369
Registered: April 2010
Location: INDIA

Senior Member

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

Regards
Deepak

Report message to a moderator

Previous Topic:	adrci issue
Next Topic:	control file block size - db_block size?

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri Apr 19 20:50:07 CDT 2024