return Table through Function
462393Mar 5 2007 — edited Mar 5 2007hi,
I tried to write one function to return Table. I wrote:
Create Or Replace Function fn_Data(strData VarChar2(500))
Return Table tb_Data(Field_1 VarChar(50))
Is
...
...
...
End
Can anybody tell me whats wrong with this syntax? or how to return table using Function? I have Oracle9i installed on my machine.
thanks in advance,
Mahesh