![what is pl sql developer what is pl sql developer](https://images-na.ssl-images-amazon.com/images/I/61o8CNoI2BL._AC_SL1000_.jpg)
Username/Password for Directory Updates: cn=orcladmin/welcome
![what is pl sql developer what is pl sql developer](https://i.ytimg.com/vi/TqDnaapi0eg/maxresdefault.jpg)
The LDAP directory using the DBMS_LDAP package.ĭirectory container for employee records: o=acme, dc=com The changes to the database table are reflected/replicated to This SQL file creates a database table called 'EMP' and creates a trigger on itĬalled LDAP_EMP which will synchronize all changes happening to the table withĪn LDAP server. These files can be found in the plsql directory under $ ORACLE_HOME /ldap/demo $Header: $Ĭopyright (c) Oracle Corporation 2000. The file empdata.sql inserts some sample data into the table EMP, which automatically gets updated to the LDAP server through the insert trigger. The file trigger.sql creates the table as well as the triggers associated with it. There are two files associated with this sample: trigger.sql and empdata.sql. The following example illustrates how changes to a table called `EMP' are synchronized with the data in an LDAP server using triggers for insert, update, and delete. The DBMS_LDAP API can be invoked from database triggers to synchronize any changes to a database table with an enterprise-wide LDAP server. Using the PL/SQL API from a Database Trigger
What is pl sql developer how to#
This chapter introduces the Oracle Internet Directory PL/SQL API and provides examples of how to use it.