Skip to Content
0

HANA Stored Procedure from Excel

Feb 23, 2017 at 03:47 AM

334

avatar image
Former Member

Hi Experts,

I've a requirement where I need to call the HANA stored procedure from within Excel Macro. This is pretty much feasible with the SQL server by using the EXEC sytatement. I can connect to the HANA system and do 'Insert/Update/display' records in the Excel by writing the code in the Macro directly. After that I wrote the same SQL to display the table record in a stored procedure. I'm trying to call the stored procedure by using Call or EXEC statement but it doesn't work ?

After that I tried to use the Microsoft Query to connect but I'm getting error 'Data Truncated' after I enter the system details and the credentials for the HANA system.

Can anyone please let me know how can I call the HANA stored Procedure from the Excel ?

Thanks for the help

Alok

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

2 Answers

Florian Pfeffer
Feb 23, 2017 at 06:13 AM
0

Please use the search here in the Community. The topic was already discussed in post Connecting HANA with Excel through VBA.

Regards,
Florian

Show 3 Share
10 |10000 characters needed characters left characters exceeded
Former Member

Florian,

I already did before posting here. Found the SAP note but that also didn't help. Would appreciate if you know about this issue and would share the solution here.

Thanks

Alok

0

W/o knowing your code/example I would be a kind of try and error approach to give you hints.

0
Former Member
Florian Pfeffer

Florian,

As I mentioned in my question, I've written the simple select query to display the table data onto excel spreadsheet. It's working fine. Now

I want to call exactly the same sql from with a stored procedure that I've created in HANA. Now instead of writing the Select * on the table, I'm calling my stored procedure using CALL/EXEC statement at the same place and storing the table data in the same variable that I was using before with my select query. To call the procedure I used this syntax, CALL "Schema_name"."Procedure_name" but I'm getting this below -

System Error &H80040E14 (-2147217900).

I tried with EXEC statement also but got same error.

Thanks

Alok

0
avatar image
Former Member Feb 27, 2017 at 05:31 AM
0

Hi,

Does anyone know the syntax of calling HANA Stored Procedure from Excel ?

Thanks

Alok

Share
10 |10000 characters needed characters left characters exceeded