8.1.6 on NT I have java installed and a java email package on instance A on a server. One the same server on instance B with global names set to false I created a public database link to instance A, then created a public synonym javamail for my email routine at A. This worked. On a third instance ( C ) on this same server with gobal names set to true (do you see where this is going) I did the same thing as I had done on instance B - but I couldn't use a short name - I had to use the full A.moto.com. Then I created a public synonym for the [EMAIL PROTECTED] This kept returning an error - couldn't find class com/moto/utils/mail - this is a home grown java class in the database A. I could not find anything different between the two setups other than one had global names set to false and the other had global names set to true (after many hours of looking and head banging) - so I just tried setting global names to false on instance C and bounced the database - went back and created a new short named public database link and then created the public synonym. It now worked ????? WHY ?? can any one tell why this works or doesn't as the case may be? -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Shaw John-P55297 INET: [EMAIL PROTECTED]
Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Lists -------------------------------------------------------------------- To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
