ORACLE执行java代码可以打印输出吗

Question

ORACLE执行JAVA代码输出在那里输出

create or replace and compile java source named test as
public class JYM {
    public static void main(){
      system.out.println("输出语句");
    }
}

问题: 输出语句在哪里可以看到

Answer 1

你其实没有必要system.out.println的语句。你可以通过return一个值，然后查看这个return值就好了，可以参考我这个例子：

create or replace and compile java source named Encrypt1 as
import java.security.SecureRandom;
import javax.crypto.Cipher;
import javax.crypto.SecretKey;
import javax.crypto.SecretKeyFactory;
import javax.crypto.spec.DESKeySpec;

public class Encrypt1 {
public static String decryptBasedDes(String cryptData) {
System.out.println("aaaa");
return cryptData;
}
}

CREATE OR REPLACE FUNCTION Encrypt11 (cryptData IN VARCHAR2)
RETURN VARCHAR2
IS
LANGUAGE JAVA
NAME 'Encrypt1.decryptBasedDes(java.lang.String) return String';

DECLARE
ABC VARCHAR2(50);
BEGIN
ABC := ENCRYPT11('aT3dGMPB2FEMba0K881Jmg==');
DBMS_OUTPUT.PUT_LINE(ABC);
END;