Error in Hana DB only

[Palaniappanst]

Method get_value and get_value_int were working fine the old oracle DB
Currently we have moved to HANA DB and we facing syntax error in both these methods.
Syntax error is on Read statement : READ TABLE me->data ASSIGNING WITH TABLE KEY key = key.
Actual Error : Component "VALUE" of key "PRIMARY_KEY" of table "ME->DATA" is not specified or is incomplete. Key must be specified in full. provided

Please help to resolve the issue.

[Palaniappanst]

changed to READ TABLE me->data ASSIGNING WITH KEY key = key.

[se38]

Hi Palaniappanst,
there's no syntax error on my HANA system.
Maybe you haven't defined the table type ZJSON_KEY_VALUE_T as "hashed table" with key field "KEY".

[Palaniappanst]

Thanks.. Issue seems to be resolved now..

…

On Thu, 16 Dec 2021, 6:31 pm Uwe Fetzer, ***@***.***> wrote: Hi Palaniappanst, there's no syntax error on my HANA system. Maybe you haven't defined the table type ZJSON_KEY_VALUE_T as "hashed table" with key field "KEY". [image: image] <https://user-images.githubusercontent.com/5384144/146376556-bbb703f1-4a91-4a8c-b1e2-de02fb2419ab.png> — You are receiving this because you modified the open/close state. Reply to this email directly, view it on GitHub <#33 (comment)>, or unsubscribe <https://github.com/notifications/unsubscribe-auth/AW6FRGWODDIOZEOWSCIOCL3URHPL7ANCNFSM5KFT525Q> . Triage notifications on the go with GitHub Mobile for iOS <https://apps.apple.com/app/apple-store/id1477376905?ct=notification-email&mt=8&pt=524675> or Android <https://play.google.com/store/apps/details?id=com.github.android&referrer=utm_campaign%3Dnotification-email%26utm_medium%3Demail%26utm_source%3Dgithub>.