OB 4.0社区版存储过程

OceanBase
#1

请问OB4.0社区版，支持存储过程了嘛？
有没有OB4.0新增特性的文档呢？

#3

4.x支持存储过程了。

文档如下
https://www.oceanbase.com/docs/community-observer-cn-10000000000901469

#4

谢谢张老师

#5

按照文档上的创建不成功呢？
obclient [test]> CREATE PROCEDURE citycount (IN country CHAR(3), OUT cities INT)
→ BEGIN
→ SELECT COUNT(*) INTO cities FROM city
→ WHERE CountryCode = country;
ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your OceanBase version for the right syntax to use near ‘country’ at line 4
obclient [test]> END;
ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your OceanBase version for the right syntax to use near ‘END’ at line 1
obclient [test]> /
→ ;
ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your OceanBase version for the right syntax to use near ‘/’ at line 1

#6

这报语法错误了，你要先了解delimiter的用法，定义一个你自己想要的delimiter来写