SapHanaTutorial.Com HOME     Learning-Materials Interview-Q&A Certifications Quiz Online-Courses Forum Jobs Trendz FAQs  
     Explore The World of Hana With Us     
About Us
Contact Us
 Apps
X
HANA App
>>>
Hadoop App
>>>
Tutorial App on SAP HANA
This app is an All-In-One package to provide everything to HANA Lovers.

It contains
1. Courses on SAP HANA - Basics, Modeling and Administration
2. Multiple Quizzes on Overview, Modelling, Architeture, and Administration
3. Most popular articles on SAP HANA
4. Series of Interview questions to brushup your HANA skills
Tutorial App on Hadoop
This app is an All-In-One package to provide everything to Hadoop Lovers.

It contains
1. Courses on Hadoop - Basics and Advanced
2. Multiple Quizzes on Basics, MapReduce and HDFS
3. Most popular articles on Hadoop
4. Series of Interview questions to brushup your skills
Apps
HANA App
Hadoop App
';
Search
Stay Connected
Search Topics
Topic Index
+
-
SQLScript
+
-
Tables in SAP HANA
+
-
Procedure
+
-
Examples of Procedure
Example of SAP HANA Procedures For Beginners


In the articles SAP HANA Procedure - Old Wine in New Bottle and Create Procedure in HANA we explained the basic features and functionalities of Procedures in SAP HANA.
Now, we will provide various examples of procedures in HANA.
SAP HANA Procedure Example
Note: You can also browse the examples from index in the left side of this page.

Example 1: How to Use Table Type in SAP HANA Procedure
This example explains how to use table type in procedure and how to send output using table type.

Example 2: How to Use Local Scalar Variable in Procedure
This example explains what scalar variable in HANA is and how to declare, initialize and use them.

Example 3: Variable Scope Nesting in Procedure
SQLScript supports local variable declaration in a nested block. In this example we have explained how visibility and scope works.

Example 4: IF-ELSE Logic in Procedure
This example shows how to declare and use conditional operator (If-Else) in procedure.

Example 5: For Loop in Procedure
In this example we have explained the use of For loop, BREAK and CONTINUE.

Example 6: Use of Array in Procedure
This examples show how to declare, initialize and use Array in procedure. It also shows how UNNEST function works on Array.

Example 7: Dynamic Filter in HANA
HANA supports dynamic filter. This example shows how to implement dynamic filtering using APPLY_FILTER method.

Example 8: Exception Handling in HANA
This example explains the use of Exception Handling in procedure.

Example 9: How to Use SIGNAL to Throw Exception
In this example we have shown how to explicitly raise an exception from within your procedures using SIGNAL.

Example 10: How to Use RESIGNAL to Throw Exception
The RESIGNAL statement raises an exception on the action statement in exception handler. This example shows the use of RESIGNAL and how it is different from SIGNAL.

Example 11: Cursor in HANA
This example explains how to implement cursor in procedure. It also explain the various performance aspect of cursor. 


Did not find what you were looking for?
If you want any specific example to be included in our list, please leave a comment or contact us at admin@saphanatutorial.com






Support us by sharing this article.



Explore More
Close X
Close X

One thought on “SAP HANA Procedure Example – Table Type, Cursor, Exception etc

  1. Alex says:

    Good collection…please add more to the list…

Leave a Reply

Your email address will not be published. Required fields are marked *

Current day month ye@r *

 © 2017 : saphanatutorial.com, All rights reserved.  Privacy Policy