Skip to Content

invalid number: not a valid number string ':i_s' at function to_int()

Jul 27, 2017 at 10:46 AM


avatar image
Former Member

Hi All,

Greetings to all.

I am trying to fetch data from HANA view through a program in se38 based on SQL queries.I have declared a variable status date type c which will contain the value of todays date. Now when i am trying to pass this variable it is giving the error as "invalid number: not a valid number string ':i_s' at function to_int()".

variable-> i_status_date(8) type c.

I am trying to pass this value as -> ('PLACEHOLDER' = ('$$STATUS_DATE_DM$$', ':i_status_date').

I have also checked in HANA view which is the only input parameter for this having data type NVARCHAR. Also tried changing the data type of variable as date and Integer but still facing the same issue.

Can anyone please help and guide how to overcome through this problem.

Thanks in Advance.

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

0 Answers