java - How to print on Oracle SQL Developer console using SQLJ -


I created and launched SQLJava process (using SQL Developer) and launched. I have some bugs and I want to debug the Java source code. What is the best way to do this? Is it possible to print a SQL developer, using some information, System.out?

itemprop = "text">

The default standard output device is the current trace file in Oracle Java Virtual Machine (JVM).

If you want to recreate all the standard output from the program executed on the server - output from any System.out. Println () calls, for example - on the user screen, you can execute the package process according to the following example

Buffer size input in bytes (10,000 bytes in this case) 

  sqlplus & gt; Execute dbms_java.set_output (10000);

Over output buffer size will be lost.

If you want to explicitly output your code to the server screen, you can use PL-Java system.out.println () instead of the method -SQL < Strong> DBMS_OUTPUT.PUT_LINE () process.