Hi All,

I have a task to insert employee data into a oracle table using
dbms_ldap, Could someone show me some pointers on how to achieve this
task.

..RA

On Aug 15, 11:01*am, janu <ang... (AT) gmail (DOT) com> wrote:
Putting dbms_ldap in the metalink knowledgebase, I poked around a bit
and came up with this: http://www.oracle.com/technology/sam...api/index.html

Of course, the zip file was empty, but what can you do?

jg
--
@home.com is bogus.
Welcome our android overseers! http://www.signonsandiego.com/uniont...b15google.html

On Aug 15, 11:01*am, janu <ang... (AT) gmail (DOT) com> wrote:
Putting dbms_ldap in the metalink knowledgebase, I poked around a bit
and came up with this: http://www.oracle.com/technology/sam...api/index.html

Of course, the zip file was empty, but what can you do?

jg
--
@home.com is bogus.
Welcome our android overseers! http://www.signonsandiego.com/uniont...b15google.html

On Aug 15, 11:01*am, janu <ang... (AT) gmail (DOT) com> wrote:
Putting dbms_ldap in the metalink knowledgebase, I poked around a bit
and came up with this: http://www.oracle.com/technology/sam...api/index.html

Of course, the zip file was empty, but what can you do?

jg
--
@home.com is bogus.
Welcome our android overseers! http://www.signonsandiego.com/uniont...b15google.html

On Aug 15, 11:01*am, janu <ang... (AT) gmail (DOT) com> wrote:
Putting dbms_ldap in the metalink knowledgebase, I poked around a bit
and came up with this: http://www.oracle.com/technology/sam...api/index.html

Of course, the zip file was empty, but what can you do?

jg
--
@home.com is bogus.
Welcome our android overseers! http://www.signonsandiego.com/uniont...b15google.html

hi jg,

thank you for your input. As recommended by you, i used dnms_ldap, but
quickly i bumped into a problem, I am getting sizeexceeded limit. so i
decided to use /usr/bin/ldapsearch to dump few fields to a text file.
but now i'm clueless on how to import data from a text file to a
table.

output(sample) looks like this
=======================

# Alex Fontana, Users, nbc.com
dn: CN=Ali Fon,CN=Users,DC=nbc,DC=com
givenName: Ali
department: Infrastructure - 19622
employeeNumber: 034636
employeeID: 034636
mail: afon (AT) nbcc (DOT) com
manager: CN=Bob Plu,CN=Users,DC=nbc,DC=com

# Aravind Pavu, Users, nbc.com
dn: CN=Aravind Pavu,CN=Users,DC=nbc,DC=com
givenName: Aravind
department: R&D: Performance - 72200
employeeNumber: 035870
employeeID: 035870
mail: apavu (AT) nbcc (DOT) com
manager: CN=Raji Kam,CN=Users,DC=nbc,DC=com

Now how do I insert each block as one row into a table. Please give me
some hints.

thank you
..ra

hi jg,

thank you for your input. As recommended by you, i used dnms_ldap, but
quickly i bumped into a problem, I am getting sizeexceeded limit. so i
decided to use /usr/bin/ldapsearch to dump few fields to a text file.
but now i'm clueless on how to import data from a text file to a
table.

output(sample) looks like this
=======================

# Alex Fontana, Users, nbc.com
dn: CN=Ali Fon,CN=Users,DC=nbc,DC=com
givenName: Ali
department: Infrastructure - 19622
employeeNumber: 034636
employeeID: 034636
mail: afon (AT) nbcc (DOT) com
manager: CN=Bob Plu,CN=Users,DC=nbc,DC=com

# Aravind Pavu, Users, nbc.com
dn: CN=Aravind Pavu,CN=Users,DC=nbc,DC=com
givenName: Aravind
department: R&D: Performance - 72200
employeeNumber: 035870
employeeID: 035870
mail: apavu (AT) nbcc (DOT) com
manager: CN=Raji Kam,CN=Users,DC=nbc,DC=com

Now how do I insert each block as one row into a table. Please give me
some hints.

thank you
..ra

hi jg,

thank you for your input. As recommended by you, i used dnms_ldap, but
quickly i bumped into a problem, I am getting sizeexceeded limit. so i
decided to use /usr/bin/ldapsearch to dump few fields to a text file.
but now i'm clueless on how to import data from a text file to a
table.

output(sample) looks like this
=======================

# Alex Fontana, Users, nbc.com
dn: CN=Ali Fon,CN=Users,DC=nbc,DC=com
givenName: Ali
department: Infrastructure - 19622
employeeNumber: 034636
employeeID: 034636
mail: afon (AT) nbcc (DOT) com
manager: CN=Bob Plu,CN=Users,DC=nbc,DC=com

# Aravind Pavu, Users, nbc.com
dn: CN=Aravind Pavu,CN=Users,DC=nbc,DC=com
givenName: Aravind
department: R&D: Performance - 72200
employeeNumber: 035870
employeeID: 035870
mail: apavu (AT) nbcc (DOT) com
manager: CN=Raji Kam,CN=Users,DC=nbc,DC=com

Now how do I insert each block as one row into a table. Please give me
some hints.

thank you
..ra

hi jg,

thank you for your input. As recommended by you, i used dnms_ldap, but
quickly i bumped into a problem, I am getting sizeexceeded limit. so i
decided to use /usr/bin/ldapsearch to dump few fields to a text file.
but now i'm clueless on how to import data from a text file to a
table.

output(sample) looks like this
=======================

# Alex Fontana, Users, nbc.com
dn: CN=Ali Fon,CN=Users,DC=nbc,DC=com
givenName: Ali
department: Infrastructure - 19622
employeeNumber: 034636
employeeID: 034636
mail: afon (AT) nbcc (DOT) com
manager: CN=Bob Plu,CN=Users,DC=nbc,DC=com

# Aravind Pavu, Users, nbc.com
dn: CN=Aravind Pavu,CN=Users,DC=nbc,DC=com
givenName: Aravind
department: R&D: Performance - 72200
employeeNumber: 035870
employeeID: 035870
mail: apavu (AT) nbcc (DOT) com
manager: CN=Raji Kam,CN=Users,DC=nbc,DC=com

Now how do I insert each block as one row into a table. Please give me
some hints.

thank you
..ra

janu (angani (AT) gmail (DOT) com) wrote:
: hi jg,

: thank you for your input. As recommended by you, i used dnms_ldap, but
: quickly i bumped into a problem, I am getting sizeexceeded limit. so i

google: oracle dbms_ldap size exceeded

shows some examples that might help to use the oracle supplied tool,

: decided to use /usr/bin/ldapsearch to dump few fields to a text file.
: but now i'm clueless on how to import data from a text file to a
: table.


google: oracle utl_file

for one method to get data from a file into oracle.



: output(sample) looks like this
: =======================

: # Alex Fontana, Users, nbc.com
: dn: CN=Ali Fon,CN=Users,DC=nbc,DC=com
: givenName: Ali
: department: Infrastructure - 19622
: employeeNumber: 034636
: employeeID: 034636
: mail: afon (AT) nbcc (DOT) com
: manager: CN=Bob Plu,CN=Users,DC=nbc,DC=com

: # Aravind Pavu, Users, nbc.com
: dn: CN=Aravind Pavu,CN=Users,DC=nbc,DC=com
: givenName: Aravind
: department: R&D: Performance - 72200
: employeeNumber: 035870
: employeeID: 035870
: mail: apavu (AT) nbcc (DOT) com
: manager: CN=Raji Kam,CN=Users,DC=nbc,DC=com

: Now how do I insert each block as one row into a table. Please give me
: some hints.

: thank you
: .ra