SQL & PL/SQL

Hi

I have a 2 schemas in my database(10.2.0.4) namely batch and publish.

I have a package index_ddl in the batch schema which selects from the dbms_metadata.get_ddl package the ddl for index creation. This package is used for dropping and recreating the indexes. it has two procedures drop_index and create_index. This package is defined with the AUTHID CURRENT_USER.

Now i have a procedure(PROC1) in the publish schema which is trying to call the procedure of the package index_ddl.drop index(which lies in the batch schema). I have granted direct access to publish for execute of index_ddl package.

When i am trying to run the PROC1 it fails at the point where the package(index_ddl.drop index) is being called with the errorORA-00942: table or view does not exist. Any suggestions how to go ahead with this.


Thanks & Regards
Ankit