Question

What does "Function created with compilation errors" mean when I try to install stored procedures in EMR

Answer 1

This may happen if while installing a stored procedure in Oracle via SQLPLUS.  To see the compilation errors run this: 

select * from SYS.USER_ERRORS where type = 'PROCEDURE'

The above will show errors for all procudures with compilation errors.  A shorter command that can be executed in SQLPLUS is:

SHOW ERRORS 

or 

SHOW ERRORS PROCEDURE

See these resources for more:

http://razorsql.com/articles/oracle_compile_errors.html

http://blog.richardknop.com/2011/04/plsql-cryptic-warning-procedure-created-with-compilation-errors/

http://docs.oracle.com/cd/B19306_01/server.102/b14357/ch12041.htm

Comments

Also see this question:
https://www.qvera.com/kb/index.php/804/ora-o6575-package-or-function-_____-is-in-invalid-state