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";
$$;
