Vsem privet !!!

Vot text functii, ona compiliruetsea no cogda I ee vipolniau ona rugaetsea na
if tab(j-1) > tab(j) then govorit tipa dannie ne naideni, ne mogu poniati pocemu, please pomoghite.

-----------------------------------------------------------------------
create or replace function BubbleSort (str VARCHAR2) return varchar2 is

Type TabNameTyp is table of VARCHAR2(250) index by binary_integer;
tab TabNameTyp;

temp CHAR;
Result VARCHAR2(250);

begin

-- introducerea elementelor stringului 'str' in tabela
for i in 1..length(str) loop
tab(i) := substr(str,i,1);
end loop;

-- sortarea tabelului dupa metoda Bubble
for i in 1..length(str)-1 loop

for j in REVERSE i..length(str)-2 loop
if tab(j-1) > tab(j) then -- RUGAETSEA POCEMU
temp := tab(j-1);
tab(j-1) := tab(j);
tab(j) := temp;

end if;
end loop;

end loop;

-- Formarea stringului sortat
Result := tab(1);
for i in 2..length(str) loop
Result := Result || tab(i);
end loop;

return (Result);
end BubbleSort;

Za ranie spasibo ...

Rebeat spasibo... vi pomogli poneati moiu osibcu, zaputalsea I v atih tablicinih indecsah. :) Net ne dly labor. A dly cego obevliati dly length(str) peremenuiu ona i bez peremenoi rabotaet. Da pridetsea poprobuvati i drughie metodi sort.

:) da I pro CPU ne podumal