How to access PostgreSQL Functions from Oracle through DBLink?
1
vote
1
answer
1355
views
I'm having two DB server (PostgreSQL, Oracle).
I'm able to access the table in PostgreSQL from Oracle through DB-Link.
I've use the below query to access the table.
select "Cust_Id", "Mobile_No" from "schema_name"."tablename"@Dblink where "cust_id" = '123456789';
As same as I'm trying to access the function in PostgreSQL from Oracle server through DBLink. But I can't access it.
I've used below query
select "Cust_id" from "schema_name"."function_name"@DbLink('123456789');
The function will return the mobileno and cust_id in table type.
I'm getting error like.
> SQL Command not properly ended
Pls help on this issue. Thnx in advance.
Asked by Ganapathy
(523 rep)
Jan 9, 2018, 01:48 PM
Last activity: Feb 14, 2025, 06:00 AM
Last activity: Feb 14, 2025, 06:00 AM