MariaDB: Create Procedures with PL/SQL Code via HeidiSQL?

Hello, afaik, MariaDB is capable of (Oracle-) PL/SQL since MDB Server Version 10.3. With a MDB installed on a Raspi I can insert PL/SQL-Code from the input line:

pi@raspberrypi:~ $ sudo mysql -u jc -p Enter password: Welcome to the MariaDB monitor. Commands end with ; or \g. Your MariaDB connection id is 66 Server version: 10.3.27-MariaDB-0+deb10u1 Raspbian 10

Copyright (c) 2000, 2018, Oracle, MariaDB Corporation Ab and others.

Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.

MariaDB [(none)]> use test Reading table information for completion of table and column names You can turn off this feature to get a quicker startup with -A

Database changed MariaDB [test]> delimiter / MariaDB [test]> CREATE PROCEDURE p2() IS -> a VARCHAR2(500); -> b CHAR(7) CHARACTER SET sjis; -> c NUMBER(6) := 1; -> d TINYINT DEFAULT 1; -> BEGIN SET @c = c; d := @d; END; -> / Query OK, 0 rows affected (0.012 sec)

MariaDB [test]>

If I try to enter the same code (different procedure name!) via HeidiSQL Query Tab, I always get errors.

"SQL Error (1064): You habe an error in your SQL Syntax: chaeck ..... to use near " at line 2."

Is there a general problem with HSQL and MariaDB PL/SQL?

Best Regards and thank you! Andree

You removed the delimiter command in HeidiSQL. That way HeidiSQL still uses the semicolon to split queries.

Alternatively, you can click the Delimiter button on the main toolbar to change it.

ansgar! You are right! Shame on me! A.