创建用户类型STRINGS_NT
CREATE OR REPLACE TYPE "STRINGS_NT" IS TABLE OF VARCHAR2(100)
FUNCTION GetPYM(
as_InputString IN VARCHAR --输入字符串
)
RETURN VARCHAR2
IS
lc_FirstLetter Strings_nt ; --存放国标一级汉字不同读音的起始区位码对应读音
BEGIN
lc_FirstLetter := Strings_nt('A', 'B','C','D','E','F','G','H','J','K','L','M','N','O','P','Q','R','S','T','W','X','Y','Z'); --使用自定义类型Strings_nt
END;