Oracle Database Discussions

Hi,

We are running Oracle 11g on linux server on a RAC environment.

One of our DBA's made a mistake of revoking all the sys object select and execute privileges from PUBLIC.
And those were like 22000 of them.
But he saved the revoke log and modified the script and went ahead and granted everything he revoked.

for example he revoked privileges like:
revoke execute on sys.dbms_random from public;
revoke execute on sys.dbms_java_test from public;
revoke execute on sys.dbms_job from public;
revoke execute on sys.dbms_java from public;
revoke execute on sys.dbms_job$ from public;
revoke execute on sys.dbms_jdm_internal from public;
revoke execute on sys.dbms_jvm_exp_perms from public;
revoke execute on utl_file from public;

and he went ahead and granted them back as:
grant execute on sys.dbms_random to public;
grant execute on sys.dbms_java_test to public;
grant execute on sys.dbms_job to public;
grant execute on sys.dbms_java to public;
grant execute on sys.dbms_job$ to public;
grant execute on sys.dbms_jdm_internal to public;
grant execute on sys.dbms_jvm_exp_perms to public;
grant execute on utl_file to public;

we also ran the @utlrp.sql script to recompile all the

But now one of our procedure don't work and they give error like below:
*"Error Text = PL/SQL: ORA-00932: inconsistent datatypes: expected - got CLOB"*
These are the same procedure which worked fine before.
But we have granted dbms_lob etc back to public, but still get this error. we have no idea as to how to fix this.

Can someone help me find a way to fix this error. Would really appreciate your help.

Philip.