Skip to Content
0

Error in creating stored procedure

Jan 19 at 02:47 PM

43

avatar image

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

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

0 Answers