testing_debug_and_optimizing_programs

The Test Window

You can use Test Window to test your program (procedures, functions, begin..end blocks etc) with a step-by-step debugging and profiling your program to look for the bottlenecks in your code. You can define input, output and input-output variables and view and assign values to variables. If a run-time error occurs during execution of the Test Script, you can view the sources of the program units that were involved in the error.

To create a Test Window press New button on the toolbar and select Test Window, or use the main menu File → New → Test Window.

HTP Output

HTP Output is useful if you develop PL/SQL Web Applications using PL/SQL Web Toolkit. HTP Output show the result of PL/SQL Web Applications script.

To use this feature click the HTP Output tab, check Enabled checkbox and execute your script. Script example:

begin
  HTP.PRINT('<html>');
  HTP.PRINT('<head>');
  HTP.PRINT('<meta http-equiv="Content-Type" content="text/html">');
  HTP.PRINT('<title>Title of the HTML File</title>');
  HTP.PRINT('</head>');
  HTP.PRINT('<body TEXT="#000000" BGCOLOR="#FFFFFF">');
  HTP.PRINT('<h1>Hello world!</h1>');
  HTP.PRINT('<p>Some text in the HTML file.');
  HTP.PRINT('</body>');
  HTP.PRINT('</html>');
end;

testing_debug_and_optimizing_programs.txt · Last modified: 2017/03/11 19:39 by administrator

Page Tools