Skip to content

Instantly share code, notes, and snippets.

@arbo-hacker

arbo-hacker/find-object-error.sql

Last active January 23, 2016 05:46
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save arbo-hacker/2e5339ab81e467aa477d to your computer and use it in GitHub Desktop.
Save arbo-hacker/2e5339ab81e467aa477d to your computer and use it in GitHub Desktop.
Download ZIP
Error de un procedimiento / funcion invalido en Oracle
Raw
find-object-error.sql
-- error de un objeto invalido
select * from sys.ERROR$ where obj#
in (select obj#
from sys.utl_recomp_invalid_all
where objname='&nombreprocedimiento'
);
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment