Skip to Content

Error in creating stored procedure

Hi experts ,

I am trying to create procedure to understand the variable scope .But I am unable to activate the procedure .It is showing me the following error :

And the code I am using is :

CREATE PROCEDURE "VCHANDRA"."VARIABLE_SCOPE_EXAMPLE"( OUT val INT) LANGUAGE SQLSCRIPT

READS SQL DATA AS

BEGIN DECLARE a INT := 1;

BEGIN DECLARE a INT := 2;

BEGIN DECLARE a INT; a := 3;

END;

val := a;

END; END;

Regards ,

Vinaya

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

0 Answers