I need to create an oracle stored procedure with 2 parameters
p1 and p2
P1 is input parameter of type numeric
p2 is output character of type varchar2(200)
My select statement is
select Field1 from table1 where field2 =:P1
This select statement will return more than 2 values
I need to loop through this two values concatnate the 2 or more values returned and send it out as an output parameter.
I tried creating a cursor and then looping through am not able to get the procedure to work.
Could any one please help.