Hana procedure syntax

pm_witmond · ‎2015 Sep 23

Hello,

I'm having problems with a simple query in a procedure.

Can anyone please help me ?

I'm trying to create a simple table filled with data

CREATE PROCEDURE pr01(IN CardCode NVARCHAR(20)) LANGUAGE SQLSCRIPT AS

BEGIN

CREATE COLUMN TABLE TEMPTBL AS (SELECT "DocNum" FROM ORDR WHERE "CardCode" =:CardCode);

END

Thanks,

Paul

patrickbachmann · ‎2015 Sep 23

Try something like this;

CREATE PROCEDURE pr01(IN CardCode NVARCHAR(20))

LANGUAGE SQLSCRIPT

SQL SECURITY DEFINER AS

BEGIN

CREATE COLUMN TABLE TEMPTBL (DOCNUM NVARCHAR(20));

INSERT INTO TEMPTBL SELECT "DocNum" FROM ORDR WHERE CardCode = :CardCode;

END

-Patrick

ROC Report