Functions and two databases
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 2 of 2

Thread: Functions and two databases

  1. #1
    Join Date
    Oct 2000
    Posts
    34
    Does anybody known how to run function (procedure) which belongs to another database?

    Thank you

  2. #2
    Join Date
    Nov 2000
    Posts
    344
    You need to make a in the database that you want to run it FROM, which connects to the database where the function resides. Then you can run it like this :

    my_variable := My_function@db_link_name;


Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  


Click Here to Expand Forum to Full Width