The following code
以下代码
CREATE PROCEDURE create_all_views()
LANGUAGE SQL
--MODIFIES SQL DATA
BEGIN ATOMIC
FOR select view_name from views_to_create DO
CREATE VIEW view_name AS SELECT * FROM view_name || '_TAB';
END FOR;
END;
produces syntax error
产生语法错误
[Code: -5581, SQL State: 42581] unexpected token: CREATE : line: 5
What is wrong here and is it possible to use DDL statements inside procedures at all?
这里有什么问题,是否可以在程序中使用DDL语句?
1 个解决方案
#1
0
The current version HSQLDB does not allow Data Definition Language statements in procedures.
当前版本的HSQLDB不允许在过程中使用数据定义语言语句。
#1
0
The current version HSQLDB does not allow Data Definition Language statements in procedures.
当前版本的HSQLDB不允许在过程中使用数据定义语言语句。