CREATE PROCEDURE Create_test3cs()
BEGIN
   EXECUTE IMMEDIATE 'CREATE TABLE "test1"
                    (
                    "id" INTEGER GENERATED ALWAYS AS IDENTITY (START WITH 0, INCREMENT BY
1) NOT NULL,
                    "name" CHAR(20) COLLATE "ANSI" NOT NULL
                    )
                    VERSION 1
                    UNENCRYPTED
                    INDEX PAGE SIZE 4096
                    BLOB BLOCK SIZE 512
                    MAX ROW BUFFER SIZE 32768
                    MAX INDEX BUFFER SIZE 65536
                    MAX BLOB BUFFER SIZE 32768';
 
  EXECUTE IMMEDIATE 'CREATE PROCEDURE "testsp1" (
                    IN pname VARCHAR
                    )
                    BEGIN
                    execute immediate ''INSERT INTO test1 VALUES (50, pname)'';
                    END
                    ';

  EXECUTE IMMEDIATE 'CREATE PROCEDURE "testsp2" ()
                    BEGIN
                    DECLARE mycursor CURSOR WITH RETURN FOR mysql ;
                    PREPARE mysql FROM ''SELECT * FROM test1'';
                    OPEN mycursor ;
                    UNPREPARE mysql ;
                    END
                    ';
END