My Oracle Support Banner

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

Last updated on JANUARY 30, 2022

Applies to:

Oracle Internet Directory - Version 9.0.4 to [Release 10gR1 to 11g]
Information in this document applies to any platform.


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

ORA-01756: quoted string not properly terminated

Also, missing following in the schema




To view full details, 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 a vibrant support community of peers and Oracle experts.