且构网

分享程序员开发的那些事...
且构网 - 分享程序员编程开发的那些事

如何在Oracle中的函数中处理异常?

更新时间:2023-08-23 14:04:34

Google [ ^ ]在你的地方破了吗?



无论如何,它看起来像这样:



 DECLARE 
声明secti on
BEGIN
Exception section
EXCEPTION
WHEN ex_name1 THEN
-Error处理语句
WHEN ex_name2 THEN
-Error处理语句
WHEN Others THEN
- 错误处理语句
END;


How to handle Exception in a function in Oracle?

Is Google [^]broken at you place?

In any case, it would look something like this:

DECLARE
   Declaration section 
BEGIN 
   Exception section 
EXCEPTION 
	WHEN ex_name1 THEN 
		-Error handling statements 
	WHEN ex_name2 THEN 
		-Error handling statements 
	WHEN Others THEN 
		-Error handling statements 
END;