[MDEV-27507] sql_mode="oracle" does not support package spec with var declaration 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   

Package specification with variable declarations are not supported

CREATE PACKAGE         MO_MO7105_ADJUST_PROC_PKG AS
    PROC_TYPE_01        NUMBER  := 1;   
    PROC_TYPE_02        NUMBER  := 2;   
    PROC_TYPE_03        NUMBER  := 3;   
    PROC_TYPE_04        NUMBER  := 4;   
 
    PROC_TYPE_FLG_SIZE  NUMBER  := 1;   
    PROC_TYPE_FLG_DATA  CHAR(1) := '1'; 
 
    TYPE REF_ADJUST_PROC_INFO IS REF CURSOR;
 
    PROCEDURE DL_ADJUST_PROC_DATA (
        I_EXEC_USER         IN  WRAP_UPL_DOWNL_MNG.LAST_EXEC_USER%TYPE
      , I_BASE_DATE         IN  DATE
      , I_BASE_PROCCESSTYPE IN  VARCHAR2
      , O_ADJUST_PROC_INFO  OUT REF_ADJUST_PROC_INFO
      , O_STATUS            OUT NUMBER
    );
 
END MO_MO7105_ADJUST_PROC_PKG;
/



 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:26 UTC 2024 using Jira 8.20.16#820016-sha1:9d11dbea5f4be3d4cc21f03a88dd11d8c8687422.