SAP HANA SQL Stored Procedure Tutorial

A procedure is a unit/module that perform a specific task. This procedure can be combined to form larger programs. This basically forms the 'Modular Design'. A procedure can be invoked by another procedure which is called the calling program.

Procedures are re-useable processing block with a specific sequence of data transformation. The procedure can have multi-input/output parameters. The procedure can be created as read-only or read-write.

An SQL Procedure can be created at:

• At Schema Level(Catalog Node)
• At Package Level(Content Node)

Stored Procedure syntax in SAP HANA is as shown below:

SYNTAX

CREATE PROCEDURE  [()] [LANGUAGE ]    
        [SQL SECURITY ] [DEFAULT SCHEMA ]
        [READS SQL DATA [WITH RESULT VIEW ]] AS
        {BEGIN [SEQUENTIAL EXECUTION]
							
        END        
        | HEADER ONLY }