oracle ¸üеĴ洢¹ý³ÌÔõôд - Oracle / ¿ª·¢

update zips set 
pref = TO_MULTI_BYTE(SYS.UTL_I18N.TRANSLITERATE(pref,'hwkatakana_fwkatakana')),
city = TO_MULTI_BYTE(SYS.UTL_I18N.TRANSLITERATE(city,'hwkatakana_fwkatakana')),
addr = TO_MULTI_BYTE(SYS.UTL_I18N.TRANSLITERATE(addr,'hwkatakana_fwkatakana'))

TO_MULTI_BYTE
Õâ¸ö·½·¨ÊÇ°ë½Ç±äÈ«½Ç
±íûÓÐKEY

---

SQL code:
CREATE PROCUDURE PRO_UPDATE
RETURN NUMBER
AS
V_RES NUMBER;
BEGIN
--ÄãµÄ¸üÐÂÓï¾ä,¸üгɹ¦Ê±ºò·µ»Ø1
V_RES=1;

--¸üÐÂʧ°Üʱ·µ»Ø-1
EXCEPTION
WHEN OTHERS THEN
V_RES=-1;

RETURN V_RES;
END;

---

V_RES=1;
COMMIT;

ÔÚÕâºóÃæ¼Ó¸öCOMMITÌá½»,ºÇºÇ,²»ºÃÒâ˼

---

ÊÇÕâÑùÂð
CREATE OR REPLACE PROCEDURE PRO_UPDATE
RETURN NUMBER
AS
V_RES NUMBER;
BEGIN
--?µÄ¸üÐÂ?¾ä,¸üгɹ¦?ºò·µ»Ø1
update zips set
pref = TO_MULTI_BYTE(SYS.UTL_I18N.TRANSLITERATE(pref,'hwkatakana_fwkatakana')),
city = TO_MULTI_BYTE(SYS.UTL_I18N.TRANSLITERATE(city,'hwkatakana_fwkatakana')),
addr = TO_MULTI_BYTE(SYS.UTL_I18N.TRANSLITERATE(addr,'hwkatakana_fwkatakana'))
V_RES=1;
COMMIT;
--¸üÐÂʧ??·µ»Ø-1
EXCEPTION
WHEN OTHERS THEN
V_RES=-1;
RETURN V_RES;
END;
µ«ÊDZ¨´í

---

ʲô´íÎó?

---

ÄãµÄ¸üÐÂÓï¾äûÓмÓ;ºÅ½áÊø