ORA-06502: PL/SQL: numeric or value error
904945May 3 2012 — edited May 8 2012Hi All,
New requirement has came so i have created some six new fields,thats done in the form page.
.All are select list fields. Front end of the form works properly .
When am trying to create a new record, record is getting created ,getting notification email also but in the report page(home page) am getting error like this.
ORA-06502: PL/SQL: numeric or value error+
I have added these six fields as six column in the parent table (varchar2 datatype).all the fields are nullable only.
I have added these six fields in the select query of the report also.
When I went to see the table, the newly created values are updated in the table, but not appearing in the front end. showing the below error
ORA-06502: PL/SQL: numeric or value error
why am getting this error??
Please some one help to resolve this error.
Many Thanks.
-Ramya.