var sidebar_align = 'right';
var content_container_margin = parseInt('290px');
var sidebar_width = parseInt('270px');
Unanswered: DBlink error
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
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.