cancel
Showing results for 
Search instead for 
Did you mean: 

Unable to call a procedure in my HANA Studio

gsatheeshkumar
Explorer
0 Kudos

Hi Frnz

I have created a decision table [WITH UPDATE VALUES] through video tutorial from HANA ACADEMY.

After successfull execution of this decision table, I just went to SQL editor and executed -->  CALL "_SYS_BIC"."STS/DECISION_UPDATE"

                                           where,     STS--> Package name

                                                           DECISION_UPDATE --> Name of my decision table.

But I am getting an error stating:   Could not execute 'CALL "_SYS_BIC"."STS/DECISION_UPDATE" '

                                                  SAP DBTech JDBC: [258] : insufficient privilege: Not authorized

Any Help will be appreciated as well as rewarded.....

View Entire Topic
sorin_radulescu
Employee
Employee
0 Kudos

It is not very clear:

DECISION_UPDATE is a table or a store procedure?

If it is a store procedure did you activate this store procedure after you created?

Did you provide access to _SYS_REPO user to schema with tables used into store procedure?

grant select on schema "name of schema" to _SYS_REPO with grant option.

I hope these suggestion will help you to find the issue.

Regards

Sorin Radulescu