Protected by Copyscape Web Copyright Protection Software

Search This Blog

Tuesday, February 4, 2014

3) APP-ALR-04108: SQL error ORA-01455: Converting column overflows integer datatype occurred while executing the user-defined SQL statement for this alert (STMT=select 12345678901 from dual)


APP-ALR-04108: SQL error ORA-01455: Converting column overflows integer datatype occurred while executing the user-defined SQL statement for this alert (STMT=select  12345678901 from dual)

 


Solution:  In Alert define window in select statement box it will accept only 10 digits columns to retrieve. So here I am retrieving 11 digits so when click on run this error occurred.

Action:  always display columns which are less than 11digits values.

Or If you want to display huge amounts then you should use to_char(amount)

so it will convert into character then it will allow more than 11 digits.
 

No comments:

Post a Comment