Procedure overloading in HANA SQL

[#1]

I want to create 2 stored procedures with different sets of params. is it possible in HANA SQL.

Example:

Create Table DEMO_TABLE ( ID INTEGER, NAME VARCHAR(10), NAME2 VARCHAR(10) );

CREATE PROCEDURE pkg_demo_entry(IN ID             INTEGER, IN NAME 		    NVARCHAR(10), IN NAME2        NVARCHAR(10) ) LANGUAGE SQLSCRIPT AS BEGIN INSERT INTO DEMO_TABLE (ID, NAME, NAME2) VALUES(:ID, :NAME, :NAME2); END ;

CREATE PROCEDURE pkg_demo_entry(IN ID             INTEGER, IN NAME 		    NVARCHAR(10) ) LANGUAGE SQLSCRIPT AS BEGIN INSERT INTO DEMO_TABLE (ID, NAME, NAME2) VALUES(:ID, :NAME, 'XXXXX'); END ;

[dvankempen]

Hi Santosh,

It is but you would have to create them in two different schema's.