|
楼主 |
发表于 2011-10-25 22:28
|
显示全部楼层
我把10-20的选项加上NLS设置,大家可以试验:
(A)
DECLARE
e1 EXCEPTION;
PRAGMA EXCEPTION_INIT (e1, -1858);
BEGIN
DBMS_OUTPUT.put_line (
TO_DATE ('13-DEC-2004 6:56 PM'
, 'DD-MON-YYYY HH:MI:SS', 'NLS_DATE_LANGUAGE=american'));
EXCEPTION
WHEN e1
THEN
DBMS_OUTPUT.put_line ('Trapped!');
END;
/
(B)
DECLARE
e1 EXCEPTION;
PRAGMA EXCEPTION_INIT (e1, -1858);
BEGIN
DECLARE
e2 EXCEPTION;
PRAGMA EXCEPTION_INIT (e2, -1858);
BEGIN
DBMS_OUTPUT.put_line (
TO_DATE ('13-DEC-2004 6:56 PM'
, 'DD-MON-YYYY HH:MI:SS', 'NLS_DATE_LANGUAGE=american'));
END;
EXCEPTION
WHEN e1
THEN
DBMS_OUTPUT.put_line ('Trapped!');
END;
/
(C)
DECLARE
e1 EXCEPTION;
PRAGMA EXCEPTION_INIT (e1, -1858);
BEGIN
DECLARE
e2 EXCEPTION;
PRAGMA EXCEPTION_INIT (e2, -1858);
BEGIN
DBMS_OUTPUT.put_line (
TO_DATE ('13-DEC-2004 6:56 PM'
, 'DD-MON-YYYY HH:MI:SS', 'NLS_DATE_LANGUAGE=american'));
END;
EXCEPTION
WHEN e2
THEN
DBMS_OUTPUT.put_line ('Trapped!');
END;
/
(D)
DECLARE
e1 EXCEPTION;
BEGIN
DECLARE
PRAGMA EXCEPTION_INIT (e1, -1858);
BEGIN
DBMS_OUTPUT.put_line (
TO_DATE ('13-DEC-2004 6:56 PM'
, 'DD-MON-YYYY HH:MI:SS', 'NLS_DATE_LANGUAGE=american'));
END;
EXCEPTION
WHEN e1
THEN
DBMS_OUTPUT.put_line ('Trapped!');
END;
/ |
|