PLSQL创建Oracle存储过程问题

判断存储过程是否编译成功

SELECT object_name, status
FROM user_objects
WHERE object_type = 'PROCEDURE' AND object_name = 'YL_COST_PROCESS';

判断存储过程编译失败的错误

SELECT line, position, text
FROM user_errors
WHERE name = 'YL_COST_PROCESS'
ORDER BY sequence;

判断存储过程是否建立成功

DECLARE
  v_count INTEGER;
BEGIN
  SELECT COUNT(*) INTO v_count
  FROM USER_OBJECTS
  WHERE OBJECT_TYPE = 'PROCEDURE'
    AND OBJECT_NAME = 'YL_COST_PROCESS'; -- 将'YOUR_PROCEDURE_NAME'替换为你要检查的存储过程名称

  IF v_count > 0 THEN
    DBMS_OUTPUT.PUT_LINE('存储过程存在');
  ELSE
    DBMS_OUTPUT.PUT_LINE('存储过程不存在');
  END IF;
END;
/