[#MDEV-16476] PL/SQL CONSTANT declarations

[MDEV-16476] PL/SQL CONSTANT declarations Created: 2018-06-12 Updated: 2023-10-18
Status:	Open
Project:	MariaDB Server
Component/s:	Stored routines
Fix Version/s:	None

Type:

Task

Priority:

Major

Reporter:

Oli Sennhauser

Assignee:

Unassigned

Resolution:

Unresolved

Votes:

Labels:

Compatibility, Oracle, pl/sql

Issue Links:

PartOf
is part of	MDEV-10872	Providing compatibility Oracle database	Open

Description

Variable declaration works:

DECLARE

  cDate  VARCHAR2(10) := '2011-10-30';

BEGIN

  NULL;

END;

Constant declaration does NOT:

DECLARE

    ->   cDate CONSTANT VARCHAR2(10) := '2011-10-30';

    -> BEGIN

    ->   NULL;

    -> END;

    -> /

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 'VARCHAR2(10) := '2011-10-30';

BEGIN

  NULL;

END' at line 2

[MDEV-16476] PL/SQL CONSTANT declarations Created: 2018-06-12 Updated: 2023-10-18