Invoke HANA Stored procedure in BODS and output to oracle table
We have a requirement to invoke a HANA SP in BODS and output the same to Oracle table. Tried to follow the document How to invoke SAP HANA stored procedures from Data Services however, it errors out in our case saying incorrect syntax.
HANA DataStore: HANA_DS
HANA Procedure Name: abcd.procedures/MCHB_TAB(HANA_DS."_SYS_BIC")
Oracle DataStore: abcd_DS
Oracle Target Table: MCHB_TAB(abcd_DS.DS_CMS)
The syntax and error message are below for your reference.
[Script:Script306] (Ln 1) : Syntax error : near </> found <DIVIDE> expecting <'('>
**FYI, our HANA stored procedures are in "_SYS_BIC" schema as were created not mentioning any specific schema. Which is why our SP name would be like - "abcd.procedures/MCHB_TAB"(HANA_DS."_SYS_BIC")
We are looking for help on executing HANA SP in BODS and output the result to Oracle tables.