• 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!

    Nikkipom795 pointsBadges:
  • 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.

    Akbarmscjnu20 pointsBadges:
  • 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...

    Jlaksmana5 pointsBadges:
  • ORA-02068 and 03113

    I have dblink in local database 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...

    Skkumar25 pointsBadges:
  • 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 link and all of...

    Tom msu15 pointsBadges:

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

Thanks! We'll email you when relevant content is added and updated.