首頁(yè) 猿問 oracle 自定義函數(shù)問題?

oracle 自定義函數(shù)問題?

NoSql

有只小跳蛙 2019-02-06 21:07:51

create or replace function f_change_zhiwu(p_string IN VARCHAR2,p_delimiter IN VARCHAR2)return varchar2 isResult varchar2 as n_length NUMBER := 0; v_tmpstr VARCHAR2(1000);n_tmpnum NUMBER := 0;beginn_length := LENGTH(p_string);for i in 0 .. n_length loopv_tmpstr := substr(p_string, i, i + 1);if v_tmpstr = p_delimiter thenResult := Result || substr(p_string, n_tmpnum, i) || '-';n_tmpnum := n_tmpnum + i + 1;end if;end loop;return(Result);end f_change_zhiwu;在第五行報(bào)如下錯(cuò)誤，如何解決：PLS-00103: 出現(xiàn)符號(hào) "AS"在需要下列之一時(shí)：:= . ( @ % ; not null rangedefault character

查看完整描述

2 回答

手掌心

TA貢獻(xiàn)1942條經(jīng)驗(yàn) 獲得超3個(gè)贊

return varchar2 is
Result varchar2
as
改成
return result varchar2 is result varchar2(100);n_length NUMBER := 0;

return  varchar2  is result varchar2(100);n_length NUMBER := 0; 多寫了一個(gè)result

反對(duì) 回復(fù) 2019-03-15

呼喚遠(yuǎn)方

TA貢獻(xiàn)1856條經(jīng)驗(yàn) 獲得超11個(gè)贊

1. Result varchar2 后加分號(hào)
2. 去掉as

如下：

create or replace function f_change_zhiwu(p_string IN VARCHAR2,
p_delimiter IN VARCHAR2)
return varchar2 is
Result varchar2;

n_length NUMBER := 0;
v_tmpstr VARCHAR2(1000);
n_tmpnum NUMBER := 0;
begin
n_length := LENGTH(p_string);
for i in 0 .. n_length loop
v_tmpstr := substr(p_string, i, i + 1);
if v_tmpstr = p_delimiter then
Result := Result || substr(p_string, n_tmpnum, i) || '-';
n_tmpnum := n_tmpnum + i + 1;
end if;
end loop;
return(Result);
end f_change_zhiwu;