Re: Back-SQL / Oracle problem - Bind variables?

["Pierangelo Masarati" <ando@sys-net.it>]

> Hi,
>
> I could not find anything about this...
>
> I am trying to install a OpenLDAP 2.0.27 on a Red Hat 7.2 as a frontend
> to a Oracle 8.1.7 using unixODBC and the proprietary Easysoft driver.
>
> Now there seems to be a problem with the bind variables used in the
> subtree select.
>
> When I set the configruation to
>
> subtree_cond "UPPER(ldap_entries.dn) LIKE
> CONCAT('%',UPPER('ou=applvl,dc=domain'))"
>
> I get the entries, while with the correct
>
> subtree_cond    "UPPER(ldap_entries.dn) LIKE CONCAT('%',UPPER(?))"

Never tried with oracle; however, I suspect a cast problem.
Depending on the cast syntax in Oracle, I'd try something
like

"UPPER(ldap_entries.dn) LIKE CONCAT('%',UPPER(cast ? as varchar(256)))"

p.

-- 
Pierangelo Masarati
mailto:pierangelo.masarati@sys-net.it