Oracle Java stored procedure in the debug information display in SQLPLUS

xiaoxiao2021-04-10  436

In the following code, sort (long) is function, returns the int type

* Adjust in SQLPLUS:

SET ServerOutput on

Call dbms_java.set_output (200000);

Variable N Number

Variable f Number

EXECUTE: N: = 302;

Call sort (: n) INTO: F;

Print f

DBMS_JAVA.SET_OUTPUT () method will set the Java output information to the SQLPLUS window


New Post(0)