lookup up srv dns record in a stored procedure?

From: Malcolm Dunnett <nothome_at_spammers.are.scum>
Date: Tue, 05 May 2009 19:56:31 -0700
Message-ID: <r%6Ml.47596$ew.36090_at_newsfe24.iad>



Oracle 10.2.0.4 Standard Edition

I'm using the DBMS_LDAP package to do lookups against Windows Active Directory. We have multiple sites so for performance reasons I'd like to   bind to the local servers, which are defined in an SRV record in DNS at:

_ldap._tcp.mysite._sites.ourdomain

(this server record will return the two local ldap servers). Because it's not "A" records I can't just use this DNS name in the hostname when

    I bind to the LDAP server. I also can't provide this dns name to UTL_INADDR (for the same reason).

Is there any package in Oracle which can do a DNS lookup on an SRV record and return the values found there. Is using UTL_TCP the only option (I presume it could be done that way but it sounds like a lot of work)? Received on Tue May 05 2009 - 21:56:31 CDT

Original text of this message