UTL_RECOMP not working
I want to recompile the invalid objects in a schema using
sql>utl_recomp.recomp_parallel('my_schema');
The command works fine but all the objects still remain invalid. Nothing changes. I run the command as sys user. There is no error in object's script because I can compile them using TOAD GUI. But I don't want to be TOAD dependent. I want to be able to compile invalid objects using utl_recomp utility. Any ideas about what might be going wrong?
Emrah