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)
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