db_link in Oracle 9i
Why I solve this problem?This error is ‘ORA-06401: NETCMN:Invalid Driver Designator.’The error occurs when I am trying to insert record through database link.

Answer Question   |  May 18, 2010  5:38 AM
DBLink, Oracle 9i, Oracle 9i Configuration, Oracle error messages

Tuning SQL query with hierarchy result through DB link
I have the below SQL query: /********************************************************************************************************/ SELECT tm_super.tm_nbr ,tm_super.tm_fname ,tm_super.tm_lname ,tm_super.super_tm_nbr ,tm_super.super_fname ,tm_super.super_lname ,tm_super.super_job FROM (SELECT papftm.employee_number tm_nbr ,paaftm.supervisor_id tm_super_id ,paaftm.person_id tm_person_id ,papftm.first_name tm_fname ,papftm.last_name tm_lname ,papfsuper.employee_number super_tm_nbr ,papfsuper.first_name super_fname ,papfsuper.last_name super_lname ,UPPER(pjsuper.name) super_job FROM per_all_assignments_f paaftm ,per_all_people_f papftm ,per_all_people_f papfsuper ,per_all_assignments_f paafsuper ,per_jobs_v pjsuper WHERE papftm.person_id = paaftm.person_id AND paaftm.supervisor_id = papfsuper.person_id AND [...]

Answer Question   |  August 11, 2009  7:22 AM
DBLink, SQL tuning

ORA-02068 and 03113
I have dblink in local database 10.2.0.3 pointing to remote database 9.2. There is a view in local database which is based on tables on remote database using dblink. When I run the select on that view, it fails with ORA-02068 and 03113. It works intermittently. It works most of the time with less records [...]

Answer Question   |  September 17, 2008  2:33 PM
DBLink, ORA-02068, ORA-03113, Oracle

Calling a SQL Server 05 Stored Procedure from Oracle
Is it possible to call a SQL Server 2005 stored procedure from Oracle? If the sp is called get_item_desc and has one input parameter (item_id), what might this call look like? Any help most appreciated!

Answer Question   |  January 16, 2009  7:20 AM
DBLink, Oracle, Oracle stored procedures, SQL Server 2005, SQL stored procedures, Stored Procedures

What causes ora-00904 error on valid fields when querying across dblink in a cursor
I have a procedure that contains a cursor that runs in a cursor for loop. The select query runs fine over the dblink all by itself, but when I try to compile the procedure, I get the PL/SQL: ORA-00904: invalid identifier on the column names. I can do a describe on the table over the [...]

Answer Question   |  June 20, 2008  11:18 PM
Cursor, DBLink, ORA-00904, PL/SQL