[Oracle][Resolved] ORA-06512: PL/SQL: numeric or value error: number precision too large.

Error message:

ORA-06512: PL/SQL: numeric or value error: number precision too large.

ORA-06512: at "SP_UPDATE_TEST", line 36

ORA-06512: at line 24

I defined the valuable length as 1.

int count NUMBER(1);

and I haven't take care that the return result count more than 9, the valuable doesn't long enough to store the result number:

SELECT COUNT(1) INTO int_count FROM ASSETS

WHERE ASSET_ID = TO_NUMBER(in_asset);

Correction:

int count NUMBER(2);

Reference:

https://www.techonthenet.com/oracle/errors/ora06502.php