PL/SQL error Ora-06502 [message #673071] |
Mon, 05 November 2018 02:32 ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
![](http://www.gravatar.com/avatar/d6fa409010f281ab46c2d056b8375879?s=64&d=mm&r=g) |
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.
|
|
|
|
|
|