[MDEV-27506] sql_mode="oracle" Variable assignment in function param clause is not supported. 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   

Variable assignment in param clause is not supported.

 
i_base  VARCHAR2 := NULL

full function:

CREATE or replace FUNCTION  PM_TO_MULTI_BYTE(
    i_base  VARCHAR2 := NULL
)
RETURN VARCHAR2
IS
    ret VARCHAR2(4000) ;
BEGIN
    ret := REPLACE( i_base, '  ', ' ' ) ;
 
    ret :=
        TO_MULTI_BYTE( TRANSLATE(
            ret,
            'Ž¡Ž¢Ž£Ž¤Ž¥Ž¦Ž§Ž¨Ž©ŽªŽ«Ž¬Ž­Ž®Ž¯Ž°Ž±Ž²Ž³Ž´ŽµŽ¶Ž·Ž¸Ž¹ŽºŽ»Ž¼Ž½Ž¾Ž¿ŽÀŽÁŽÂŽÃŽÄŽÅŽÆŽÇŽÈŽÉŽÊŽËŽÌŽÍŽÎŽÏŽÐŽÑŽÒŽÓŽÔŽÕŽÖŽ×ŽØŽÙŽÚŽÛŽÜŽÝ',
            '¡£¡Ö¡×¡¢¡¦¥ò¥¡¥£¥¥¥§¥©¥ã¥å¥ç¥Ã¡¼¥¢¥¤¥¦¥¨¥ª¥«¥­¥¯¥±¥³¥µ¥·¥¹¥»¥½¥¿¥Á¥Ä¥Æ¥È¥Ê¥Ë¥Ì¥Í¥Î¥Ï¥Ò¥Õ¥Ø¥Û¥Þ¥ß¥à¥á¥â¥ä¥æ¥è¥é¥ê¥ë¥ì¥í¥ï¥ó'
        ) )
    ;
 
    ret := REPLACE( ret, '¥«ŽÞ', '¥¬') ;
    ret := REPLACE( ret, '¥­ŽÞ', '¥®') ;
    ret := REPLACE( ret, '¥¯ŽÞ', '¥°') ;
    ret := REPLACE( ret, '¥±ŽÞ', '¥²') ;
    ret := REPLACE( ret, '¥³ŽÞ', '¥´') ;
    ret := REPLACE( ret, '¥µŽÞ', '¥¶') ;
    ret := REPLACE( ret, '¥·ŽÞ', '¥¸') ;
    ret := REPLACE( ret, '¥¹ŽÞ', '¥º') ;
    ret := REPLACE( ret, '¥»ŽÞ', '¥¼') ;
    ret := REPLACE( ret, '¥½ŽÞ', '¥¾') ;
    ret := REPLACE( ret, '¥¿ŽÞ', '¥À') ;
    ret := REPLACE( ret, '¥ÁŽÞ', '¥Â') ;
    ret := REPLACE( ret, '¥ÄŽÞ', '¥Å') ;
    ret := REPLACE( ret, '¥ÆŽÞ', '¥Ç') ;
    ret := REPLACE( ret, '¥ÈŽÞ', '¥É') ;
    ret := REPLACE( ret, '¥ÏŽÞ', '¥Ð') ;
    ret := REPLACE( ret, '¥ÒŽÞ', '¥Ó') ;
    ret := REPLACE( ret, '¥ÕŽÞ', '¥Ö') ;
    ret := REPLACE( ret, '¥ØŽÞ', '¥Ù') ;
    ret := REPLACE( ret, '¥ÛŽÞ', '¥Ü') ;
    ret := REPLACE( ret, '¥ÏŽß', '¥Ñ') ;
    ret := REPLACE( ret, '¥ÒŽß', '¥Ô') ;
    ret := REPLACE( ret, '¥ÕŽß', '¥×') ;
    ret := REPLACE( ret, '¥ØŽß', '¥Ú') ;
    ret := REPLACE( ret, '¥ÛŽß', '¥Ý') ;
    ret := REPLACE( ret, '¥¦ŽÞ', '¥ô') ;
 
    RETURN ret;
END ;
 
/



 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.

Comment by Michael Widenius [ 2020-06-07 ]

This is a new feature that we are working on

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