Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

Invoke HANA Stored procedure in BODS and output to oracle table

Hi All,


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.


Syntax:

HANA_DS._SYS_BIC.abcd.procedures/MCHB_TAB (MCHB_TAB(abcd_DS.DS_CMS);


Error:

[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.


Thanks!

Former Member
Not what you were looking for? View more on this topic or Ask a question