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 <proc_name> [(<parameter_clause>)] [LANGUAGE <lang>]    
        [SQL SECURITY <mode>] [DEFAULT SCHEMA <default_schema_name>]
        [READS SQL DATA [WITH RESULT VIEW <view_name>]] AS
        {BEGIN [SEQUENTIAL EXECUTION]
				<procedure_body>			
        END        
        | HEADER ONLY }

The CREATE PROCEDURE statement creates a procedure using the mention programming language <lang>.

SYNTAX ELEMENTS