Variable ____oracle can be defined in an Oracle cursor

2008/03/07
Skate

A variable can be defined in a cursor, and the following is an example of the procedure of my Update column order

Create or replace
PROCEDURE TEST as
--v_id varchar2;
--V_num number;
--v_x number;
I number (10,0): = 1;

v_id VARCHAR2 (32);
V_num number (10,0);
V_x number (10,0);


Cursor Cur_ids is
Select Id,sum from (
Select count (ID) sum,id from m_category_t where ordernumber = 0 GROUP by ID)
where Sum >1;

Cursor CUR_IDS1 is
Select CategoryID from m_category_t where id=v_id;

Begin
Open cur_ids;
Loop
Fetch cur_ids into V_id,v_num;
Exit when Cur_ids%notfound;

Open cur_ids1;
Loop
Fetch CUR_IDS1 into v_x;
Exit when Cur_ids1%notfound;

Update m_category_t set ordernumber=i where categoryid=v_x;
i:=i+1;
End Loop;
Close cur_ids1;
I:=1;
End Loop;
Close Cur_ids;
End TEST;

--End--