on 01-24-2017 2:04 PM
I have an AMDP method, with parameter IMPORTING VALUE(threshold) TYPE decfloat16
Within the AMDP is a complex select which uses to_bigint( :threshold ).
When I try to execute the method, I get a database error:
invalid number: [339] "SYSID"."ZCL_HANA_TABLE=>MY_METHOD#stb2#20170124144446": line 8 col 3 (at pos 177): [339] (range 3) invalid number exception: invalid number: [339] invalid number: not a valid number string 'C11C309000000000' at function to_bigint() (please check lines: 9)
I've check in the ABAP debugger and threshold contains the value 1048576.
If I replace :threshold with a number, the SQL works fine.
See Mapping of ABAP Types to SQLScript under
http://help.sap.com/abapdocu_751/en/index.htm?file=abenamdp_hdb_sqlscript.htm
decfloat16 -> VARBINARY, length 8. Cannot be interpreted as a number in the database and no calculations can be performed
decfloat34 -> VARBINARY, length 16. Cannot be interpreted as a number in the database and no calculations can be performed
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
84 | |
24 | |
12 | |
9 | |
7 | |
6 | |
5 | |
5 | |
4 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.