Some basic datatypes and functions in oracle compatibility mode do not work (MDEV-19162)

[MDEV-19149] sql_mode="oracle" errors on DBMS_OUTPUT and subfunctions Created: 2019-04-02  Updated: 2019-09-10

Status: Open
Project: MariaDB Server
Component/s: None
Affects Version/s: None
Fix Version/s: None

Type: Technical task Priority: Major
Reporter: Manjot Singh (Inactive) Assignee: Unassigned
Resolution: Unresolved Votes: 0
Labels: Compatibility


 Description   

This example from Oracle tutorials throws errors:

CREATE OR REPLACE PROCEDURE procPrintHelloWorld
 
IS
 
BEGIN
 
  DBMS_OUTPUT.PUT_LINE('Hello World!');
 
END;
 
/

The DBMS_OUTPUT line throws "ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near '' at line 4"

https://www.techonthenet.com/oracle/procedures.php

We should provide equivalents for the most used DBMS packages.

 Comments   
Comment by Manjot Singh (Inactive) [ 2019-05-29 ]

We can provide this package by default by creating analogous functions: https://www.fromdual.com/select-hello-world-fromdual-with-mariadb-pl-sql

Comment by Alexander Barkov [ 2019-09-10 ]

This probably will need "SET PATH" to be implemented first.

Generated at Thu Feb 08 08:49:25 UTC 2024 using Jira 8.20.16#820016-sha1:9d11dbea5f4be3d4cc21f03a88dd11d8c8687422.