Referring to How to execute an Oracle stored procedure via a database link, it does not work in my case. I don\'t know what I am missing.
Can someone please shed some light on how to install the requirements for Postgres 9 (Centos) to be able to use dblink for inter-postgres db querying.
I have a strange problem with my nested cursors and I have no idea what it\'s all about. Here\'s my T-SQL code:
I am used to Oracle and to create a dblink in my schema and then access to a remote database like this: mytable@myremotedb, is there anyway do to the same wi开发者_如何学Pythonth PostgreSQL?
I have two DB\'s one is f开发者_运维知识库eed by filtered data from another, now i\'m using perl script witch executes query on foreign DB, stores a result in a csv file, and loads it to local DB usin
I\'m a newbie with DBLink and Sqlite. When DbMetal generates Nortwind.cs (C#) it marks some methods with a Table attribute:
Here is the scenario: Oracle A: charset WE8ISO8859P1 Oracle B: charset WE8MSWIN1252 Oracle A <- dblink -> Oracle B
I have a stored procedure FOO belonging to user A.User B has EXECUTE permission on FOO. One of the procedures in FOO uses a DB Link to retrieve data from BARTABLE@REMOTEDB.A has a DB Link to REMOTEDB
I am having a bit of trouble with a select into insert across a dblink in oracle 10.I am using the following statement:
I am tring to use db link for that I have first change the name of both databases to sol1(remote) and sol3(local) then I create a db link