create
or replace Function Generate_Series (
MinNumber INTEGER,MaxNumber INTEGER,NumberToSkip INTEGER
) Return Numbers_t
As
newNumber INTEGER: = MinNumber;
Numbers_t Numbers_x: = Numbers_t();
Begin
for x in (
with s as (
Select
rNo
From
(
select
level rno
from
dual connect by level <= enNumber
) A
Where
A.rNo >= stNumber
)
select
rno
from
s
) loop
if x.rno <> MinNumber then
newNumber: = newNumber + NumberToSkip;
end if;
if newNumber >= MaxNumber then
Return;
end if;
Numbers_x.EXTEND;
Numbers_x(Numbers_x.COUNT): = newNumber;
end loop;
Return Numbers_x;
End;
看到此错误
"Function GENERATE_SERIES compiled
LINE/COL ERROR
--------- -------------------------------------------------------------
0/0 PL/SQL: Compilation unit analysis terminated
13/8 PLS-00320: the declaration of the type of this expression is incomplete or malformed
Errors: check compiler log"
有人可以帮我这个TIA。