Top "Database-link" questions

ORA-02019: connection description for remote database not found

I have created a db link AM_ADMIN throufh SQL Developer: I am trying to check if it is a …

oracle database-link
How do I create a Database Link where remote and local are the same server

I have a need to create a database link that is a link to a schema on the same server. …

oracle database-link
How to create a database link in MySQL to connect to Oracle?

I need to create a database link in MySQL to connect to an Oracle database to use a table present …

mysql oracle database-link
Can't create Database Link to remote DB in Oracle-DB

We have a CRM system in our company, which uses an Oracle 11g database. It is developed by a third …

oracle database-connection database-link heterogeneous-services
Calling oracle function using database link

I have created a oracle function called getEmployee(id in varchar) in my remote database and I'm trying to call …

sql oracle database-link ora-24338
ORA-03150: end-of-file on communication channel for database link

In an Oracle database there's a big PL/SQL procedure being executed periodically that copies data from one DB to …

sql oracle exception database-link
How to call function using dblink in oracle?

Is it possible to call a function using DBLINK in oracle? I am calling the function like this and getting …

oracle11g database-link
Oracle database link. Check for existence or overwrite?

I need to check if a database link already exists before I create one. How can I do that? I …

oracle plsql database-link
on using oracle database link theres an error "ORA-12154 TNS Could not resolve the connect identifier specified"

I'm trying to define a database link on oracle 10.2 with connection identifier that throws the error in the question header. …

oracle database-link
How do I close the cursor created in a database link(ORA-02080)?

I perform the following sequence of steps(step-wise using F-9) in Oracle SQL Developer: create database link mydb connect to …

sql oracle database-connection database-link database-cursor