MSCEWI3012

Call to an external program is not supported.

This is a deprecated version of the SnowConvert documentation, please visit the official site HERE.

Severity

Medium

Description

Calls to external Java or C programs are not supported. The clause is commented inside the procedure body.

Example Code for stored procedures

Input Code:

CREATE OR REPLACE EDITIONABLE PROCEDURE PROC01 
AS LANGUAGE JAVA NAME 'oracle.wh.service.impl.data.analysis.procedures.ForeignKey.CreateKey(int,java.lang.String)';

Output Code:

CREATE OR REPLACE PROCEDURE PROC01 ()
RETURNS STRING
LANGUAGE JAVASCRIPT
EXECUTE AS CALLER
AS
$$
   /*** MSC-ERROR - MSCEWI3012 - CALL TO AN EXTERNAL JAVA PROGRAM IS NOT SUPPORTED ***/
   /*  LANGUAGE JAVA NAME 'oracle.wh.service.impl.data.analysis.procedures.ForeignKey.CreateKey(int,java.lang.String)'*/
   ;
$$;

Example Code for functions

Input Code:

CREATE OR REPLACE EDITIONABLE FUNCTION FUN4 (n number) return varchar2 AUTHID CURRENT_USER as
language java name
'oracle.AWAction.Interaction.Execute(oracle.sql.CLOB) return java.lang.String';

Output Code:

CREATE OR REPLACE FUNCTION PUBLIC.FUN4 (n FLOAT)
RETURNS STRING
LANGUAGE JAVASCRIPT
AS
$$
   /*language java name*/
   /*'oracle.AWAction.Interaction.Execute(oracle.sql.CLOB) return java.lang.String'*/
   return "Call external programs is not supported";
$$;

Recommendations

• No additional user actions are required.

• If you need more support, you can email us at [email protected]