Hi Gurus,
I have a requirement where i need to build the Cursor dynamically where the number of Columns in the Select statement are not fixed, it keeps on changing and the result of the select statement need to pass to some other Record type which is an IN parameter for a seeded Oracle API. How we can do achieve it. Please fined the pseudo logic below.
Declare
l_api_rec_typ HZ_PARTYV2PUB.PARTY_REC_TYPE;
BEGIN
Select Col1.....Col5 into L_rec_type ---(which can be build based on the select statement Dynamically)
from dual;
-- Now the output of the above select statement needs to pass to the l_api_rec_type
l_api.rec_type.Col1:= l_rec_typ.Col1;
l_api.rec_type.Col2:= l_rec_typ.Col2;
l_api.rec_type.Col2:= l_rec_typ.Col3;
HZ_PARTY_V2PUB.CREATE_ORGANISAZTION (
l_api_rec_typ......x_msg_data,x_return_status ...etc);
END;
In the Above code the number of columns in select statements keeps on changing. So how i can assign the output of the Sleect Statement to the API record Type.
Thanks In Advance...
Thanks