ERROR ORA-06521 / ORA-01756 When Using DBMS_LDAP Package (Doc ID 303296.1)

Last updated on JUNE 30, 2017

Applies to:

Oracle Internet Directory - Version 9.0.4 to 11.1.1.7.0 [Release 10gR1 to 11g]
Information in this document applies to any platform.
***Checked for relevance on 08-Mar-2013***


Symptoms

1) Gets the following error when executing a pl/sql procedure written using DBMS_LDAP APIs

ORA-06521: PL/SQL: Error mapping function
ORA-06512: at "SYS.DBMS_LDAP_API_FFI", line 0
ORA-06512: at "SYS.DBMS_LDAP", line 1338
ORA-06512: at "SYS.DBMS_LDAP", line 1273
ORA-06512: at "SYS.DBMS_LDAP", line 529
ORA-06512: at line 108

All the DBMS_LDAP packages ( DBMS_LDAP, DBMS_LDAP_UTL,DBMS_LDAP_API_FFI) exist under SYS schema and all are VALID.

 

2) Another symptom

ERROR:
ORA-01756: quoted string not properly terminated

Also, missing following in the schema

DBMS_LDAP.init
DBMA_LDAP.open_ssl
DBMS_LDAP.simple_bind_s

 

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms