![]() | ![]() Products ![]() ![]() ![]() ![]() |
Home » Technical Support » ElevateDB Technical Support » Incident Reports » Incident Reports Addressed for Version 1.04 » View Incident Report |
![]() |
Reported By: Joseph Reported On: 7/5/2007 For: Version 1.04 Build 4 |
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
This web page was last updated on Tuesday, April 23, 2024 at 08:39 AM | Privacy Policy![]() © 2024 Elevate Software, Inc. All Rights Reserved Questions or comments ? ![]() |