Oracle LDAP Search/Bind function

I'm trying to create an authentication function that can perform a search/bind.

The algorithm for this is as follows:
1) Bind to the LDAP server as the application (ie: admin username and password)
2) Search the LDAP directory for the sign-in username %userid%
3) Get the DN of that entry
4) Unbind as the application
5) Bind as the sign-in username %userid% with the DN from above

I'm pretty sure that this is possible with the DBMS_LDAP and DBMS_LDAP_UTL packages, but I'm not sure how to put it all together. Does anyone out there know if a function such as this already exists?

Oracle LDAP search timeout

I have some problems with the package DBMS_LDAP and the function search_s.There is a criteria that when I try to filter with it, my process always timeout. When I try with any other criteria, it works fine. Anyone can explain what can be the source of the problem ? ...

Oracle LDAP Username Edit Function

I want to add 'uid=' to username before LDAP authentication starts.I have created a function:create or replace function "ADD_UID"(t_no in VARCHAR2)return VARCHAR2isbeginreturn ('uid='||t_no);end; and then I have referenced it in 'LDAP Username Edit Function' field like this:return ADD_UID(:P9_USERNA ...

Oracle LDAP Username edit function

I am using LDAP authentication. I created a function with the following signaturecreate or replace function myfunc( un IN varchar2) return varchar2When I invoke this function in sqlplus, I get the required result.Now I created an authorization schema and am invoking the function in the Username edit ...

Oracle LDAP search

How can I make LDAP search work with APEX? I can use LDAP built in function for access but containers have to be specified after user id. My LDAP server is on Netware. ...

Oracle LDAP Search & Find # of Directs

I have a typical requirement... the client wants to find a managers total reportees at runtime from LDAP, has anyone done anything similar to this before?I have a sample code that will get me the details for any employee but do not know how to convert it into a function that will return either the # ...

Oracle LDAP.IS_MEMBER function

I am using the APEX_LDAP.IS_Member API to determine if the currentuser is a member of a specific group. The function always returns False unless the full search path is specified for p_auth_base parameter. The p_auth_base is defined as "LDAP search base, for example, dc=users,dc=my,dc=org." The only ...

Oracle OTN Search Function Broken

OracleJSP: oracle.jsp.provider.JspCompileException: Errors compiling:/u01/app/oracle/product/IAS904/j2ee/OC4J_Portal/application-deployments/wwwotn/wwwotn/persistence/_pages//_searchotnerr.javaLine # Error 219[jsp src:line #:498]cannot resolve symbol symbol : class PrintWriter location: class _searc ...

Oracle Forum search function really, Really, REALLY needs to be made useful.

The search function on these forums is infantile.You guys really need to bring in a professional-grade solution for searching the forums. Without it, it is very difficult for people to find high relevance matches for their specific problems, even if such posts are repeatedly made in the specific for ...

Oracle trying to bind parameters of call to package/function for current record.

I've created a jdbc call to my pl/sql stored package/procedure. It works fine with static values used as the parameters. ie. String query = "begin :1 := findogx.nogx(33,3333); end;";Now I want to pass values into this package/function that can change depending on the rowset that my user is currenly ...

Oracle Date search in region of function returning query

Raj, Hope all is well!!!I have a report region that is of type function returning sql query. At the end My function returns: s||' '||f||' '||w;(select||from||where) is built in the function and it works now w/bunch of filters based on elements on page...I have two date elements on my page: p15_sdate ...

Oracle LDAP (OID) search fails on binary data

I am trying to perform OID search with filter like this:"(&(cn=test*)(usercertificate=*))" and getting error:javax.naming.OperationNotSupportedException: [LDAP: error code 53 - Function Not Implemented]; remaining name ''(if perform programmatically)andldap_search: DSA is unwilling to performlda ...

Oracle Exact syntax for the LDAP Username Edit Function

I have followed the How-To on setting up LDAP as an authentication method but I am having trouble specifying the "Username Edit Function".I have a database table which contains a list of user email addresses and associated distinguished name (dn) as stored in an external LDAP...I populated this tabl ...

LDAP-SEARCH() function - Question

I use ldap-search() to bind and query Oracle Internet Directory(OID). OID returns a Warning message if the user passowrd is going to expire in a certain preset time. In this case, ldap:bindResponse() is a sucess, but with the WARNING message attached to the response. LDAP browsers and command line t ...

ldap-search with ldap v3 bind?

I am trying to use dp:ldap-search extension function on ldap server which allows only ldap v3 bind and I am getting following error from ldap server:Bind error : Only LDAP v3 is supported.DataPower log:14:07:30 ldap error 1021105 93.136.26.192 0x80e0018d Error querying server ldap_server_addr: Could ...

Oracle how to use function v( ) for bind variable > 30 char

I have the following process, try to load columns from table to the page. One of the column complains about > 30 char cannot use bind variable. I change to V('c1.OBJ_OUT_SOURCIING_WAD_TYPE') but still not work.Please help;BEGINFOR c1 in ( SELECT * FROM #OWNER#.OBJECT_OUT_SOURCINGWHERE OBJ_NAME = ...

Oracle report pl/sql function body returning query bind variable

I really like using report with a function returning sql. I have been using something like thisdeclareq varchar2(10000);beginq := 'select col1from mytable';.... add a dynamic where clause ....return q;end;But I thought it would be nice to store the query in a bind variable so that I could show the w ...

Oracle LDAP call using a stored function

I am trying to use one of our stored function with the HMTLDB database (like LDAP_GET_FIRST_NAME) within an HTMLDB application. When I issue the following command within SQLPLUSselect cw_ldap_get_first_name('<my_ldap_name>', '<my_password>') from dual;my first name is displayed by SQLPLU ...

Oracle Lost search function in Popup LOV

With some help from a few here I had a good Popup LOV from a query working just fine. Search, Close, next, prev functions all worked. Come back today and now when I attempt to search for a value I get a 404 page error. Tried deleting the field, creating a new one and changing the type to popup lov f ...

Oracle special search function

I am having some trouble with the search function. I use the following syntax for a simple search:SELECT * FROM reports WHERE instr(upper("REP_NAME"),upper(nvl(:P340_SEARCH,"REP_NAME"))) > 0 That works perferctly well. Now, I want to add another text field where the column to search in can be spe ...

Oracle Intermedia search on blobs doesn't function on linux

We are developping a web application with java and we use the intermedia (oracle text: Oracle 9) engine for searching blob content. The sql query for searching on blob functions well wenn we install the oracle server on a windows machine. On linux machines, we obtain no results for the query.We have ...

Oracle Ranking search function on one column

We need to search on many docs saved in database. These LOBs has one column KEYWORD VARCHAR2 (64), in which we should put some words that help user who want to search on these values. Is there any explanation (code) how to rank found docs by this KEYWORD field. Something like google but much poorer ...

Oracle Ranking search function based on column content

We need to search on many docs saved in database. These LOBs has one column KEYWORD VARCHAR2 (64), in which we should put some words that help user who want to search on these values.Is there any explanation (code) how to rank found docs by this KEYWORD field. Something like google but much poorer a ...

Oracle LDAP Function Connects to AD - Password expiration

We have a function that connects APEX to Active Directory. When the user password is about to expire in active directory, the flag is changed to 1. This is causing the user login with APEX to fail. How can we prevent this? ...

Oracle LDAP autentication with LDAP username edit function

For LDAP authentication I did everything as it is described in this link:http://www.oracle.com/technology/products/database/application_express/howtos/how_to_ldap_authenticate.htmlI am using Edit LDAP user function created by me and it is working if I am referring to it from PL/SQL scripts, but in L ...

Oracle Attempting to test Function with Bind Variable --- What am I doing wrong?

When I try to test a function (ComputeFreight) with a bind variable, I get an error, returned....."SQL> EXEC :ComputeFreight :=V_ComputeFreight;BEGIN :ComputeFreight :=V_ComputeFreight; END;*ERROR at line 1:ORA-06550: line 1, column 25:PLS-00201: identifier 'V_COMPUTEFREIGHT' must be declaredORA- ...

Oracle Active Directory LDAP search.. question

I really need your help on the below issue. I've been searching the forum and trying various things but haven't figured out exactly how to make it work. I want to authenticate users via AD - LDAP. I managed to do this thanks to Niall's page. http://www.niall.litchfield.dial.pipex.com/2005/11/using-a ...

Oracle LDAP Authentication using custom function hangs

I am fairly new to APEX and I am trying to use an LDAP authentication function I wrote on the DB inside APEX.I am using APEX version 3.1 on DB 11.1.0.6 with embedded gateway.I have a function that returns a boolean result against active directory. I can execute it fine from SQL+, but when I try to c ...

Oracle LDAP authentication with pre bind lookup

I am currently using htmldb_custom_auth.ldap_authenticate for LDAP authentication in my application. The way it is now the DN string needs to have the DN value hard wired but is it possible to have this changed to using a search value - such as using a search DN to find the USER and then authenticat ...

Oracle dbms_ldap SSL bind with 3rd party ldap

Has anyone successfully done an SSL bind using the dbms_ldap package with a 3rd party ldap such as SunONe or Active Directory? If so, could you describe how you did it. We have not been able to even do a bind. We get the dreaded ORA-31202 error. Other forums indicate that dbms_ldap SSL does not work ...