Variable database link in cursor

Setup:

Multiple databases (all 8.1.7.2.x) on multiple W2K servers

Background:

I created a procedure to update a local table with data retrieved from a remote database. The (public) database link information was "hard-coded" in the procedure. Everything worked fine.

Problem:

I now need to update the local table from multiple remote databases (all identical column / table structure). I have all of the database links created, but can't figure out how to pass a variable for the database link. I've been trying to set up a reference cursor but can't figure out how to do this and be able to pass the database link to the procedure.

I've been trying to uncover whatever I could from Oracle documentation, Metalink, Google, etc. but can't seem to get database link part figured out.

Any help or pointers greatly appreciated.

Thanks,

Don Received on Sat Feb 01 2003 - 20:27:36 CST