RE: LDAP

Stephane,

This was very interesting...I am still
"perking" on this...i have looked at
the dbmsldap package, and admit to some
ignorance....it seems that this PL/SQL
package is good for making calls to
OID (Oracle's LDAP) but I do not
see how these package calls could be
used to access the Netscape/iPlanet
tool. Is this via the "OpenLDAP libraries" you cited?

Have you the time to illuminate further?

With thanks, and apologies for thick-headedness,

• Ross

-----Original Message-----
Sent: Wednesday, June 13, 2001 4:42 PM
To: Multiple recipients of list ORACLE-L

"Mohan, Ross" wrote:
>
> Anyone have any idea when/if the Net8 clients will
> support/interface with Netscape/iPlanet LDAP offerings?
>
> Any thoughts welcome...!
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author: Mohan, Ross
> INET: MohanR_at_STARS-SMI.com
>

Ross,

   I don't know if this has anything to do with your problem but I was looking for a way to make Oracle applications access the contents of a Netscape LDAP server. The idea was to map pseudo-tables upon PL/SQL tables (using the object option) so as to enable applications to issue SELECT * FROM LDAP$... types of queries. The problem is of course first to map the essentially hierarchical structure of a LDAP directory into relational tables (Back to the Future IV), and to create 'derived' views to hold multivalued attributes, and, as I am lazy, to do it automatically. I have a program (currently very ugly) written using OpenLDAP libraries which connects to the Netscape server and 'shows' (text mode, yek) the contents. You select the information you want to map with Oracle and it generates code to do it. Charlie Mengler has pointed me to the DBMS or UTL LDAP package, which can be used to fill the PL/SQL tables with the proper info. In my case, there was a snag, which is that it cannot work with MTS - and I have MTS. So I also generate C code for a daemon. I have a prototype in which the daemon writes a file used as cache which is then read with UTL_FILE by the PL/SQL function which fills the tables. Not very smart but it works. I am putting the last touch to another daemon which gets requests and sends info through an Oracle pipe, thus acting as a kind of proxy for the LDAP server. Would like to turn this into a true product, but still very far from it.

-- 
HTH,

Stephane Faroult
Oriole Corporation
Voice:  +44  (0) 7050-696-269 
Fax:    +44  (0) 7050-696-449 
Performance Tools & Free Scripts
--------------------------------------------------------------
http://www.oriole.com, designed by Oracle DBAs for Oracle DBAs
--------------------------------------------------------------
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Stephane Faroult
  INET: sfaroult_at_oriole.com

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).
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Mohan, Ross
  INET: MohanR_at_STARS-SMI.com

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).