Skip to Content
avatar image
-1
Former Member

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

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.

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

0 Answers