OraFAQ Forum: Server Administration » db-link as parameter

Home » RDBMS Server » Server Administration » db-link as parameter

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

db-link as parameter [message #369656]

Tue, 08 February 2000 15:15

naeem
Messages: 6
Registered: February 2000

Junior Member

Hello,
Is there a way to pass db link as parameter to a procedure.
My quary is as follows
Cursor test
is
select column1,
column2
From table1@Db_link
Is anybody have come accros this kind of problem.
Naeem

Report message to a moderator

Re: db-link as parameter [message #369658 is a reply to message #369656]

Fri, 11 February 2000 14:55

Greg Skakun
Messages: 10
Registered: January 2000

Junior Member

use a lexical variable:

select count(*) from employee@&db_link;

Report message to a moderator

Re: db-link as parameter [message #369664 is a reply to message #369656]

Thu, 17 February 2000 15:32

naeem
Messages: 6
Registered: February 2000

Junior Member

Thanks,
It will be the same when you use inside a procedure, b'cause the object is not recognised by at the moment of compilation
Naeem

Report message to a moderator

Previous Topic:	help again
Next Topic:	How to get, if the item is database item.

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri Jun 09 00:33:45 CDT 2023