Execute function from remote Oracle database through Oracle ODBC gateway

From: Garry Chen <garry(dot)c(at)cornell(dot)edu>
To: "pgsql-novice(at)lists(dot)postgresql(dot)org" <pgsql-novice(at)lists(dot)postgresql(dot)org>
Subject: Execute function from remote Oracle database through Oracle ODBC gateway
Date: 2020-02-06 21:21:32
Message-ID: CAB8F913-340F-4AB9-A004-10FB75D1E8A3@cornell.edu
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-novice

Hi All,
I am wondering how to call a postgresql function from Oracle database through Oracle ODBC gateway. I have Oracle gateway configured and dblink named pgrempte created and test in a Oracle databse. I can do select * from “ dbsec”(dot)test_tab(at)pgremote in Oracle sqlplus and returned result set. How can I call postgresql function named “dbsec”.sp_proc(‘char’,’char2’) from remote Oracle database which has the dbllink named pgremte created? Can it be done?

Thank you very much,
Garry

Browse pgsql-novice by date

  From Date Subject
Next Message Adam Middleton 2020-02-07 17:37:52 Southern California 2020 Linux Expo Emails
Previous Message Stephen Frost 2020-02-05 20:39:21 Re: Password aging