PL/SQL error Ora-06502 [message #673071] |
Mon, 05 November 2018 02:32 |
|
kmack
Messages: 2 Registered: November 2018
|
Junior Member |
|
|
I am getting ORA-06502 PL/SQL numeric or value error from the below select statement in reports builder 6i
select to_char(to_date(lateby, 'sssss'), 'mi:ss')
from attendancelogs
where emp_no = :emp_no
and attendancedate = :dat;
late number(15);
The same statement when run under SQL*Plus is running fine without any error and fetching values the way I want.
The field lateby in the attendancelogs table is defined as number(10). It is an integer value having 3 digits from 0-999 and i am coverting this integer to give me hours:minutes:seconds.
I am using Reports builder 6i and Oracle 11g database.
Any help will be much much appreciated x 1000 times.
|
|
|
|
|
|