[suse-oracle] LDAP Authentication from Oracle 10g to Novell Netware 6.5

Dear All,

I would like to get authentication from Oracle database 10g to my Novell Netware 6.5 ldap server. I have written following code but it is giving me error message. I have installed DBMS_LDAP package as well.

CREATE OR REPLACE
PROCEDURE PROCEDURE1 AS
BEGIN
--SET SERVEROUTPUT ON SIZE 1000000
DECLARE
  -- Adjust as necessary.
  l_ldap_host    VARCHAR2(256) := '192.168.100.146';
  l_ldap_port    VARCHAR2(256) := '389';
  l_ldap_user    VARCHAR2(256) := 'cn=test';
  l_ldap_passwd  VARCHAR2(256) := 'irma1234';
  l_ldap_base    VARCHAR2(256) := 'cn=Users,dc=irma,dc=ac.in';

  l_retval       PLS_INTEGER; 
  l_session      DBMS_LDAP.session;
  l_attrs        DBMS_LDAP.string_collection;
  l_message      DBMS_LDAP.message;
  l_entry        DBMS_LDAP.message;
  l_attr_name    VARCHAR2(256);
  l_ber_element  DBMS_LDAP.ber_element;
  l_vals         DBMS_LDAP.string_collection;
BEGIN
  -- Choose to raise exceptions.
  DBMS_LDAP.USE_EXCEPTION := TRUE;

  -- Connect to the LDAP server.
  l_session := DBMS_LDAP.init(hostname => l_ldap_host,
                              portnum  => l_ldap_port);

  l_retval := DBMS_LDAP.simple_bind_s(ld     => l_session,
                                      dn     => l_ldap_user,
                                      passwd => l_ldap_passwd);

  DBMS_OUTPUT.PUT_LINE('Connected...');  

  -- Disconnect from the LDAP server.
  l_retval := DBMS_LDAP.unbind_s(ld => l_session);
  DBMS_OUTPUT.PUT_LINE('L_RETVAL: ' || l_retval);
  end;
END PROCEDURE1;


Error Message:

Connecting to the database prmnt.
ORA-31202: DBMS_LDAP: LDAP client/server error: No such object. NDS error: no such entry (-601)
ORA-06512: at "SYS.DBMS_SYS_ERROR", line 86
ORA-06512: at "SYS.DBMS_LDAP", line 1455
ORA-06512: at "SYS.DBMS_LDAP", line 79
ORA-06512: at "PRMNT.PROCEDURE1", line 30
ORA-06512: at line 2
Process exited.
Disconnecting from the database prmnt.


Kindly help me in resolving this.

Regards
Trusha


      Unlimited freedom, unlimited storage. Get it now, on http://help.yahoo.com/l/in/yahoo/mail/yahoomail/tools/tools-08.html/

_______________________________________________
suse-oracle mailing list
[email protected]
http://listx.novell.com/mailman/listinfo/suse-oracle