[MDEV-27505] sql_mode="oracle" cannot declare variable as constant Created: 2020-05-14  Updated: 2024-01-12

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

Type: Task Priority: Major
Reporter: Manjot Singh (Inactive) Assignee: Unassigned
Resolution: Unresolved Votes: 0
Labels: Compatibility, Oracle


 Description   

'CONSTANT' keyword in variable declaration is not supported.

CREATE or replace  PROCEDURE FF_POSITION_BACK_PROC
 
(
 
  G_RET_CODE VARCHAR2
 
) AS
 
  G_PGMID         VARCHAR2(30) := 'FF_POSITION_BACK_PROC';
 
  G_PROC                  VARCHAR2(250);
 
 
  G_ZERO          CONSTANT NUMBER := 0;          
 
 
BEGIN
 
 
 
null;
 
 
 
 
 
END FF_POSITION_BACK_PROC;



 Comments   
Comment by Julien Fritsch [ 2020-06-02 ]

manjot We only support the most important subset of PL/SQL so far. This MENT is a features which is outside of the currently supported subset.

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