<div>
<div class="content wysiwyg-content">
Hi 
 
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. 
 
Thanks 
 
Madhavi
</div>
</div>

Hi 

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.

Thanks

Madhavi

Oracle stored Procedure (P1 in numeric, p2 out varchar)

Databases are organized collections of data, most commonly accessed through management systems including schemas, tables, queries and processes that allow users to enter and manipulate the information or utilize it in other fashions, such as with web applications or for reporting purposes.