To Customer defined Oracle function always one string parameter will be passed

(see chapter 2.1) .

ConnectMaster AutoNaming expects a VARCHAR as part of the object name.

Uniqueness will be checked based on defined bind level in ConnectMaster.

Be aware:        Some ConnectMaster AdminTool functions clean the SCHEMA cmsys,

         therefore Customer defined functions have to be re-installed !

 

CREATE OR REPLACE FUNCTION LOCLEVEL3 ( istring IN VARCHAR2 )

     RETURN VARCHAR

     IS

     result VARCHAR(50);

     BEGIN

     result := substr(istring,0,30);

     RETURN result;

     END;

/

GRANT EXECUTE ON CMSYS.LOCLEVEL3 TO CMSELECT;

/

GRANT EXECUTE ON CMSYS.LOCLEVEL3 TO CMFULL;

/

CREATE OR REPLACE PUBLIC SYNONYM LOCLEVEL3 FOR CMSYS.LOCLEVEL3;

/

COMMIT;