User Tools
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;
Page Tools
