cancel
Showing results for 
Search instead for 
Did you mean: 

When we will go for stored procedure in SAP HANA?

Former Member
0 Kudos

We can achieve everything through information views, then in which scenarios we will create stored procedure?

Thanks

Accepted Solutions (1)

Accepted Solutions (1)

lbreddemann
Active Contributor
0 Kudos

No, you can't. And in these cases you use stored procedures.

Keep in mind that scripted calculation views are also just stored procedures.

- Lars

Former Member
0 Kudos

Thanks Lars. I wanted know like we have functionality in SAP HANA to create stored procedure also. So any scenarios in which we cant do  through  views and we will create stored procedure for that. Like performance issue or any other .....

lbreddemann
Active Contributor
0 Kudos

I am not sure what you are really asking here.

There is a lot what you could do with SQL or the semantics that information views provide.

But sometimes writing procedural code is clearer or more efficient or easier or all of the just mentioned things together.

It's another tool in your toolbox.

Sometimes you like to have a chisel even though you could whack a hammer against your screwdriver...

- Lars

Former Member
0 Kudos

Thanks Lars. I got my answer in your reply what I was looking for

Answers (0)