RE: PL/SQL and external procedures -- Linux :-) Solaris :-(

From: Norwood Bradly A <Bradley.A.Norwood_at_M1.IRSCOUNSEL.TREAS.GOV>
Date: Sat, 24 Jun 2000 22:07:46 -0400
Message-Id: <10538.110370@fatcity.com>

But your note and response may have helped somebody in our Oracle world today or at some other time, or led to procedural note-taking in many sites. Thanks for sharing, Robert.

-----Original Message-----

From: Robert Eskridge [mailto:bryny_at_dfweahs.net] Sent: Friday, June 23, 2000 7:44 PM
To: Multiple recipients of list ORACLE-L Subject: Re: PL/SQL and external procedures -- Linux :-) Solaris :-(

How come I can never figure these things out until I write a big long note in here?

The problem turned out to be a line in sqlnet.ora on the Solaris machine.

NAMES.DEFAULT_DOMAIN = world

That was keeping the EXTPROC_CONNECTION_DATA alias from being recognized. I've found I can get it working by either commenting out the line in sqlnet.ora or by changing the alias to EXTPROC_CONNECTION_DATA.world (which looks funny but works).

Sorry I took up bandwidth with this.

-rje

R> I've RTFM'd until my eyes are crossed and I can't see what is going
R> wrong.  I've taken the code and configurations from
R> http://www.orafaq.org/scripts/c_src/extproc.txt and implemented them
R> verbatim.  (And compared it to the PLSQL manual, the Oracle 8
R> Administration Guide and Fuuerstein's book.)

--

Author: Robert Eskridge
  INET: bryny_at_dfweahs.net

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: ListGuru_at_fatcity.com (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). Received on Sat Jun 24 2000 - 21:07:46 CDT