Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

ORA-04042: procedure, function, package, or package body does not exist

915922Aug 3 2012 — edited Aug 3 2012

getting following error

I have logged on as sys

GRANT EXECUTE ON CTXSYS.CTX_DDL TO public
*
ERROR at line 1:
ORA-04042: procedure, function, package, or package body does not exist

does it need Oracle text installed
comp_name
Oracle Database Catalog Views
Oracle Database Packages and Types
Oracle Workspace Manager
JServer JAVA Virtual Machine
Oracle XDK
Oracle Database Java Packages
Oracle Expression Filter
Oracle XML Database
Oracle Rules Manager
Oracle Multimedia
Oracle Real Application Clusters

Locked Post

New comments cannot be posted to this locked post.

Locked on Aug 31 2012

Added on Aug 3 2012

#general-database-discussions

3 comments

2,690 views