SQL>  @d:\exDocsDraft\ldap\plsql_ldap_search.sql
+++++++++++++++++++++++++++++++++++++++++++++++++++                                                 
> DBMS_LDAP Search Example                                                                          
> LDAP Host              : dec4100.exzilla.net                                                      
> LDAP Port              : 389                                                                      
> Ldap session           : 14450E21(returned from init)                                             
> simple_bind_s Returns  : 0                                                                        
> search_s Returns       : 0                                                                        
> LDAP message           : AC800E21(returned from search_s)                                         
> Number of Entries      : 8                                                                        
+++++++++++++++++++++++++++++++++++++++++++++++++++                                                 
dn: dc=exzilla,dc=com                                                                               
dc : exzilla                                                                                        
objectclass : top                                                                                   
objectclass : domain                                                                                
---------------------------------------------------                                                 
dn: o=SALES,dc=exzilla,dc=com                                                                       
objectclass : top                                                                                   
objectclass : organization                                                                          
o : SALES                                                                                           
---------------------------------------------------                                                 
dn: o=SUPPORT,dc=exzilla,dc=com                                                                     
objectclass : top                                                                                   
objectclass : organization                                                                          
o : SUPPORT                                                                                         
---------------------------------------------------                                                 
dn: o=MARKETING,dc=exzilla,dc=com                                                                   
objectclass : top                                                                                   
objectclass : organization                                                                          
o : MARKETING                                                                                       
---------------------------------------------------                                                 
dn: o=EDUCATION,dc=exzilla,dc=com                                                                   
objectclass : top                                                                                   
objectclass : organization                                                                          
o : EDUCATION                                                                                       
---------------------------------------------------                                                 
dn: uid=fuju@exzilla.com, o=SALES,dc=exzilla,dc=com                                                 
cn : Fuju Graham	                                                                                   
title : Sales Manager                                                                               
userpassword : 807DAD7B8B0641F1FBE054F006480FE1                                                     
givenname : Fuju                                                                                    
objectclass : person                                                                                
objectclass : inetorgperson                                                                         
objectclass : organizationalperson                                                                  
objectclass : top                                                                                   
sn : Graham                                                                                         
telephonenumber : +1 408 827 0371                                                                   
employeenumber : 1100401                                                                            
uid : fuju@exzilla.com                                                                              
---------------------------------------------------                                                 
dn: mail=teddy@exzilla.net, o=SALES,dc=exzilla,dc=com                                               
cn : Teddy Graham                                                                                   
sn : Graham                                                                                         
mail : teddy@exzilla.net                                                                            
title : Presales                                                                                    
objectclass : top                                                                                   
objectclass : inetorgperson                                                                         
objectclass : organizationalperson                                                                  
objectclass : person                                                                                
employeenumber : 1100402                                                                            
telephonenumber : 3283-3920392-32932                                                                
description : Linux enthusiast                                                                      
givenname : Teddy                                                                                   
---------------------------------------------------                                                 
dn: mail=spidix@exzilla.net,o=MARKETING,dc=exzilla,dc=com                                           
cn : Spider Webb                                                                                    
sn : Webb                                                                                           
givenname : Spider                                                                                  
mail : spidix@exzilla.net                                                                           
description : Spider on the net                                                                     
title : Support Manager                                                                             
telephonenumber : 870-28912-221                                                                     
objectclass : top                                                                                   
objectclass : person                                                                                
objectclass : organizationalperson                                                                  
objectclass : inetorgperson                                                                         
employeenumber : 1100403                                                                            
---------------------------------------------------                                                 
unbind_res Returns       : 0                                                                        
Directory operation Successful .. exiting                                                           

PL/SQL procedure successfully completed.

SQL> spool off