create or replace view
	PROC_ERROR
as
select * 
 from USER_ERRORS

create or replace view
	PROC_LIST
as
select OBJECT_NAME as "プロシージャ名" 
	,STATUS as "状態"  
	,OBJECT_TYPE  as "タイプ" 
	,CREATED  as "作成日" 
	,LAST_DDL_TIME  as "更新日" 
from USER_OBJECTS 
where OBJECT_TYPE in ('FUNCTION','PROCEDURE') 

create or replace view
	PROC_TEXT
as
select * from USER_SOURCE