Can't execute package

[MikeJones]

Hello,

I'm having trouble running the Oracle supplied DBMS_OBFUSCATION_TOOLKIT package. I don't think my problem is specific to this package though.

When I try to run it I get the following error

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

However I can describe the package, It's public procedures etc.

It's status in DBA_objects is also "valid"

Finally I have been given execute priv on it.

Can anybody help me?

Thanks,

Mike.

 

[MikeLacey]

hi mike,

have you run catalog and catproc on this instance?
Mike
michael.j.lacey@ntlworld.com

 

[prosenjit]

Would like to go through the syntax you are using .

Prosenjit

 

[duperdog]

Make sure you are calling the procedure as owner.procedure(args)