SQL> conn scott/tiger
已连接。
SQL> select object_name,object_type from user_objects where object_name='RM_ALLATHLETE_INFO';OBJECT_NAME OBJECT_TYPE
-------------------------------------------------- -------------------
RM_ALLATHLETE_INFO PROCEDURESQL> select object_name,procedure_name from user_procedures where object_name='RM_ALLATHLETE_INFO' or procedure_name='RM_ALLATHLETE_INFO';未选定行
存储过程RM_ALLATHLETE_INFO只存在于user_objects视图,却不存在于user_procedures 中,这是什么原因造成的呀?
------------------------------------------------------------------------------------
OBJECT_TYPE
--------------------------------------
KQHZ
PROCEDURESQL> select object_name,procedure_name from user_procedures where object_name='KQHZ' or procedure_name='KQHZ';OBJECT_NAME
------------------------------------------------------------
PROCEDURE_NAME
------------------------------------------------------------
KQHZ跟你的不一样
select * from all_procedures where owner=user
回复3楼:select * from all_procedures where owner=user 仍没有找到这个这个存储过程.