Results 1 to 2 of 2

Thread: DBlink error

  1. #1
    Join Date
    Feb 2003
    Location
    Malaysia
    Posts
    2

    Unanswered: DBlink error

    Hi,

    I manage to get data with the below query statement in editor script
    select * FROM dwh_admin.v_pmt_tools_mg@dwh;

    where by dwh is a dblink.

    However, i get the below error once i put the query statement into a package:

    12:07:09 ORA-02019: connection description for remote database not found

    May i know what is happenning to the dblink? Thanks

  2. #2
    Join Date
    Dec 2003
    Location
    Oklahoma, USA
    Posts
    354
    In the package, make sure to specify the link exactly as it is defined. Most likely, it should be "dwh.world"

    I "think" this has to do with sqlnet.ora on the local machine (when you run a query) and the server (adding to a package), but I haven't had time to check it fully.

    Hope this works for you.

    JoeB

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •