Home » RDBMS Server » Server Administration » db-link as parameter
db-link as parameter [message #369656] Tue, 08 February 2000 15:15 Go to next message
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
Re: db-link as parameter [message #369658 is a reply to message #369656] Fri, 11 February 2000 14:55 Go to previous messageGo to next message
Greg Skakun
Messages: 10
Registered: January 2000
Junior Member
use a lexical variable:

select count(*) from employee@&db_link;
Re: db-link as parameter [message #369664 is a reply to message #369656] Thu, 17 February 2000 15:32 Go to previous message
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
Previous Topic: help again
Next Topic: How to get, if the item is database item.
Goto Forum:
  


Current Time: Fri Oct 23 17:06:32 CDT 2020