SAP HANA SQLScript · Procedures, Functions & Libraries

SQL SECURITY DEFINER vs INVOKER on a procedure — whose authorizations get checked at run time?

Answer locked. Get the free KnowCard app to reveal it — plus spaced-repetition review so it actually sticks.

This is one card from the KnowCard library — thousands more across SAP, Linux, Python and more. In the app you get the answer, AI explanations, and cards that come back right before you would forget them. Free to start on iOS, Android or the web.

More in Procedures, Functions & Libraries

A colleague wants to hide business logic by shipping a procedure WITH ENCRYPTION. What must you warn them about?

Inside another procedure/block, you write statustexts(iv_langu => 'DE', et_result => lt_x); with no CALL. Valid?

Calling a procedure, you pass a brand-new variable name to an OUT table parameter that was never declared. Error?

Can a SQLScript procedure call itself? Since which version, and what's the limit?

The DETERMINISTIC keyword sounds like a free speed-up for a scalar UDF. On SPS 05, what actually happens?

You need a read-only subroutine whose result you can join inside a SELECT. Procedure or function — and why?

Start learning today

Free to start — download the app or use it in your browser.