Home » RDBMS Server » Server Administration » PL/SQL LDAP API
PL/SQL LDAP API [message #52877] Mon, 19 August 2002 04:25 Go to next message
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
Re: PL/SQL LDAP API [message #52879 is a reply to message #52877] Mon, 19 August 2002 04:31 Go to previous messageGo to next message
Mahesh Rajendran
Messages: 10708
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
run catldap.sql again.
and try to compile & call the procedure again.
Re: PL/SQL LDAP API [message #52882 is a reply to message #52879] Mon, 19 August 2002 04:51 Go to previous messageGo to next message
Mahesh Rajendran
Messages: 10708
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.

   

Re: PL/SQL LDAP API [message #52885 is a reply to message #52879] Mon, 19 August 2002 05:00 Go to previous messageGo to next message
Mahesh Rajendran
Messages: 10708
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.
Re: PL/SQL LDAP API [message #52887 is a reply to message #52885] Mon, 19 August 2002 05:03 Go to previous message
Josh
Messages: 9
Registered: August 1999
Junior Member
No, I'm not getting ORA-04968.
Previous Topic: Re: ORA-12571: TNS:packet writer failure
Next Topic: i need help on the following situation
Goto Forum:
  


Current Time: Thu Dec 26 10:39:01 CST 2024