OraFAQ Forum: Server Administration

Home » RDBMS Server » Server Administration » PL/SQL LDAP API

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

PL/SQL LDAP API [message #52877]

Mon, 19 August 2002 04:25

Josh
Messages: 9
Registered: August 1999

Junior Member

I'm trying to use the DBMS_LDAP package to interface with an ldap server. I installed the package as the oracle instructions said, which seemed to have worked. But whenever I call one of the functions in the PL/SQL script it get the following error:

ORA-06508: PL/SQL: could not find program unit being called

This doesn't make any sense to me becuase the script recognizes the function call because it doesn't give me any compilation errors, but when I call it it's not found. Has anybody else ran into this problem?

Thanks,
Josh

Report message to a moderator

Re: PL/SQL LDAP API [message #52879 is a reply to message #52877]

Mon, 19 August 2002 04:31

Mahesh Rajendran
Messages: 10707
Registered: March 2002
Location: oracleDocoVille

Senior Member
Account Moderator

run catldap.sql again.
and try to compile & call the procedure again.

Report message to a moderator

Re: PL/SQL LDAP API [message #52882 is a reply to message #52879]

Mon, 19 August 2002 04:51

Mahesh Rajendran
Messages: 10707
Registered: March 2002
Location: oracleDocoVille

Senior Member
Account Moderator

Okie.
1. try to execute the package/procedure again.
2. If showing errors,
   try to recompile it again using 
   alter command.

Report message to a moderator

Re: PL/SQL LDAP API [message #52885 is a reply to message #52879]

Mon, 19 August 2002 05:00

Mahesh Rajendran
Messages: 10707
Registered: March 2002
Location: oracleDocoVille

Senior Member
Account Moderator

and
are u getting a ORA-04068 along with??
if so, some depended object ( like a table) is been altered. so, the program unit is actually in a invalid state during the execution.
check the status of the function or procedure.

Report message to a moderator

Re: PL/SQL LDAP API [message #52887 is a reply to message #52885]

Mon, 19 August 2002 05:03

Josh
Messages: 9
Registered: August 1999

Junior Member

No, I'm not getting ORA-04968.

Report message to a moderator

Previous Topic:	Re: ORA-12571: TNS:packet writer failure
Next Topic:	i need help on the following situation

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri Sep 20 02:08:29 CDT 2024