请问我的函数错在哪?

[Benny007ok]

CREATE OR REPLACE FUNCTION GetOfficeNameListByIDList(officeIDList VARCHAR2(200))
RETURN VARCHAR2 IS

--DECLARE officeIDList VARCHAR2(200);
officeNameList VARCHAR2(300);
ID VARCHAR2(10);
ind INT;
BEGIN
--officeIDList := '2,34,1,65,32';
IF officeIDList = ''THEN
RETURN '';
END IF;
officeIDList := LTRIM(officeIDList, ',');
officeIDList := RTRIM(officeIDList, ',');
officeIDList := officeIDList || ',';
ID := '';
officeNameList := '';
WHILE INSTR(officeIDList, ',') IS NOT NULL AND INSTR(officeIDList, ',') > 0
LOOP
ind := INSTR(officeIDList, ',');
ID := LEFT(officeIDList, ind - 1);
SELECT officeNameList := officeNameList || F_OrganiseName || ',' FROM TS_Organise WHERE F_ID := CONVERT(INT, ID);
officeIDList := SUBSTR(officeIDList, ind || 1, (LEN(officeIDList) - ind));
END LOOP;
officeNameList := SUBSTR(officeNameList, 0, LEN(officeNameList));
RETURN officeNameList;
END GetOfficeNameListByIDList;
如题!

[LGQDUCKY]

CREATE OR REPLACE FUNCTION GetOfficeNameListByIDList(officeIDList VARCHAR2(200))


VARCHAR2(200))改为VARCHAR2




SELECT officeNameList := officeNameList || F_OrganiseName || ',' FROM TS_Organise WHERE F_ID := CONVERT(INT, ID);

[Benny007ok]

错误的意思是指语法上错在哪!

[Benny007ok]

不行啊!还是错的!

[chinaup]

报的什么错误

[Benny007ok]

编译的时候没报错!不过在
select GetOfficeNameListByIDList('2,34,1,65,32') from dual
时候说我的函数无效

[Benny007ok]

没人能回答我吗？
这只是一个普通的一个函数啊!

[大道至简VP]

SELECT officeNameList := officeNameList || F_OrganiseName || ',' FROM TS_Organise WHERE F_ID := CONVERT(INT, ID);
改成：SELECT officeNameList = officeNameList || F_OrganiseName || ',' FROM TS_Organise WHERE F_ID = CONVERT(INT, ID);

[liuyi8903]

用pl/sql dev单步调度一下吧！

[beyondrobey]

officeIDList := LTRIM(officeIDList, ',');
officeIDList := RTRIM(officeIDList, ',');出错.因为你传的是'2,34,1,65,32'.
你应该养成好的错误处理习惯.

[guangli_zhang]

具体环境是什么？
目的是什么？
看不太懂
我用的是Oracle 9好像没有函数left

[Benny007ok]

TO beyondrobey() :
officeIDList := LTRIM(officeIDList, ',');
officeIDList := RTRIM(officeIDList, ',');
我这两句是为了适应有时候可能会传入是',2,34,1,65,32,'两边或一边有逗号的情况.