Dear Members
I need a function to return rows
this is my sample data
ID DESC UNI CODE
1 BO_USER 40352 A
2 BO_USER1 40353 D
3 BUSINESS_PARTNER1 40353 F
4 BUSINESS_PARTNER2 40354 R
5 BUSINESS_PARTNER3 40354 N
if i pass the id and uni as a input value i need to get the entire row as a result
Create or replace function ((ID in varchar2, UNI in varchar2)
return
l_val;
Itry to use tpe as table
and type as object and call this in the function , but when i try to call this value , i am not able to
use the function name in stead of that i need to use
slect * form table the function name
if somene post some syntax how to do that i will follow
regads