RJoshi,
Set up a database link to the package-owning schema on your "Demo" db, as I demonstrate here:
SQL> drop database link joshi;
Database link dropped.
SQL> create database link joshi
2 connect to dontdrop identified by dontdrop using 'fos';
Database link created.
SQL> col a heading "Number to Word translation" word_wrap
SQL> select dh_util.spell@joshi(12345678901.2345678) a from dual;
Number to Word translation
--------------------------------------------------------------------------------
Twelve Billion Three Hundred Forty-Five Million Six Hundred Seventy-Eight
Thousand Nine Hundred One and Two Million Three Hundred Forty-Five Thousand Six
Hundred Seventy-Eight / Ten Millionths
1 row selected.
[/code]
Also of note when creating database links are Turkbear's comments from thread759-731639:
"The tnsnames.ora on the database server is the one that needs the info about the linked database instance, not the one on your client. ( I won't reveal how many times that one has bitten me in the a__)
Also, the link name is controlled, to some extent, by the GLOBAL_NAMES parameter in the remote databases init file.
If it is set to TRUE, then the link name must be the same as the database name. Otherwise you can call the link anything you want."
Let me know if this is what you want and if it works for you.
![[santa] [santa] [santa]](/data/assets/smilies/santa.gif)
Mufasa
(aka Dave of Sandy, Utah, USA @ 18:30 (17Dec03) GMT, 11:30 (17Dec03) Mountain Time)