Ads were blocked - no problem. But keep in mind that developing HeidiSQL, user support and hosting takes time and money. You may want to send a donation instead.

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

amshh's profile image amshh posted 1 month ago in General Permalink

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

1 attachment(s):
  • hsqlplsql
ansgar's profile image ansgar posted 1 month ago Permalink

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.

amshh's profile image amshh posted 1 month ago Permalink

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

Please login to leave a reply, or register at first.




Ads were blocked - no problem. But keep in mind that developing HeidiSQL, user support and hosting takes time and money. You may want to send a donation instead.