oracle 移植 postgresql 函数inout转换
有没有人能帮忙看一下以下oracle pl/sql怎么转换为 plpgsql
Procedure GetSubStringByDelim(vOriginal IN varchar2,
vTableIndex in out BINARY_INTEGER,
vStrArray in out str_array)
IS
tIndex Integer;
tSubString varchar2(100);
BEGIN
if vOriginal is null or trim(vOriginal) = '' then
return;
end if;
tSubString := vOriginal;
tIndex := instr(tSubString, ';');
if tIndex = 0 then
if trim(tSubString) = '' then
return;
else
vTableIndex := vTableIndex + 1;
vStrArray.extend;
vStrArray(vTableIndex) := trim(tSubString);
return;
end if;
end if;
if tIndex > 1 then
vTableIndex := vTableIndex + 1;
vStrArray.extend;
vStrArray(vTableIndex) := substr(tSubString, 1, tIndex - 1);
end if;
tSubString := substr(tSubString, tIndex + 1, length(tSubString) - tIndex);
GetSubStringByDelim(tSubString, vTableIndex, vStrArray);
END GetSubStringByDelim;