Oracle Java stored procedure in the debug information display in SQLPLUS

xiaoxiao2021-04-10  526

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

转载请注明原文地址:https://www.9cbs.com/read-133267.html

New Post(0)