lkrishna
asked on
How do I rectify the ORA-06502: PL/SQL:
var_count := var_count + 1;
If var_count >= 10 then
var_count := 0;
v_block := v_block +1 ;
-- commit;
DBMS_OUTPUT.PUT_LINE('Comm
end if;
end if;END IF;
END;
END LOOP;
dbms_output.put_line('No of rows updated-='|| v_block * 10 + var_count);
END;
ORA-06502: PL/SQL: numeric or value error: character to number conversion error
ORA-06512: at line 125
-----
If I remove the following line, the code is working fine.
dbms_output.put_line('No of rows updated-='|| v_block * 10 + var_count);
How do I show the total number of records fetched in the cursor...
var_count and v_block declared as below. Kindly let me know as to the error in the above code.
var_count number(4) default 0;
v_Block number(4) 0;
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Thanks to all . This helped and I am able to get the total number of records through dbms_output.put_line. thanks for your help
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
change to:
DBMS_OUTPUT.PUT_LINE('Comm