存储过程含大量sql语句

@liaosnet：我参照官网上的指南：教程，如下写了一个例子，bigquery的值写什么，以及这个存储过程的外部调用语句该怎么写？
DROP PROCEDURE IF EXISTS P_GenerateCode;
CREATE PROCEDURE P_GenerateCode
(
tabid int,
tabname NVARCHAR(100)
)

EXEC SQL BEGIN DECLARE SECTION;
char bigquery[270] = "begin work;";
EXEC SQL END DECLARE SECTION;
stcat ("SELECT * from systables WHERE tabid = ? and ", bigquery);
stcat ("tabname = ?;', bigquery);
EXEC SQL prepare bigq from :bigquery;

EXEC SQL execute bigq using :tabid, :tabname;

EXEC SQL commit work;

END PROCEDURE

@liaosnet：

@GBase用户24232：drop function if exists proc_execsql(int);
create function proc_execsql(p_id int)
returns int as rc;
define v_sql_err int;
define v_sqlstr lvarchar(16384);

on exception set v_sql_err
return v_sql_err;
end exception;

let v_sqlstr = '';

let v_sqlstr = 'delete from user1 where id = ' || p_id;
execute immediate v_sqlstr;
return 0;
end function;
call proc_execsql(1);