how to use procedures in cursor

[micgrath]

I want to use procedure within a cursor
how can I use it

I want to pass multiple rows output to the procedure and that procedure should take that value one by one bez in my procedure i gave one argument

e.g. select ccy_pair from deal_detail;
this qry returns 432 rows
i want to pass each row to the procedure
bez in procedure i have done some calculation which is based on above ccy_pair field

plz guide me how can i solve this problem

[holdingbe]

I want to use procedure within a cursor
how can I use it

I want to pass multiple rows output to the procedure and that procedure should take that value one by one bez in my procedure i gave one argument

e.g. select ccy_pair from deal_detail;
this qry returns 432 rows
i want to pass each row to the procedure
bez in procedure i have done some calculation which is based on above ccy_pair field

plz guide me how can i solve this problem

Hi,
In select statements, function can be used not procedure..pls convert into your procedure into function and then use it..

Thanks and regards
Michael Holding

[debasisdas]

It will be better to use the cursor with the procedure body and apply the logic u need to implement in side the cursor in a loop.