Chat now with support
Chat with Support

SQL Navigator for Oracle 7.4 - Installation Notes

HTML Viewer

Show HTML in the integrated viewer.

This eliminates the need to switch from your coding environment to an external browser.

TIP:

  • Enable Capture Web Output so each time you execute PL/SQL code, the generated HTML is displayed in the integrated viewer. If the PL/SQL procedure is run under the debugger, the HTML output is not visible until the procedure is complete.

  • You can select links and submit forms from the integrated viewer. If the link or submit target is another PL/SQL generated page then that page appears in the viewer. If it is an external link then an error message will appear. You must fill in the Web Support Configuration Dialog for this to work correctly.

  • Use the Web Support Configuration Dialog to specify where images can be loaded or enter the details of your web server's configuration.

  • Click View in External Web Browser to open the page in your default Windows web browser.

    This is useful for testing links to pages that are not PL/SQL generated. SQL Navigator will map images as defined in the Web Support Configuration Dialog, but this mapping will only apply to the generated page. All links, frame sources and your browser and Web server, not SQL Navigator, will handle form posting.

  • Click File | Print to print the page.

 

Stored Procedure > HTML

Developing Oracle Web server applications involves programming with PL/SQL using the PL/SQL Web toolkit supplied with Oracle Web Server. SQL Navigator provides an integrated development environment with advanced coding, testing and debugging of PL/SQL programs for Oracle Web server.

Actions Description

Enable the web server

Select Session | Capture Web Output.

Open the procedure for editing.

Code Web Server Procedures in the Code Editor.

The editor includes drag and drop coding for Web toolkit packages, including htp and htf items.

Execute the procedure.

Execute the procedure in the Code Editor.

Note: You can use the SQL Navigator Debugger to step through the stored procedure, if you want to debug the generation of HTML. However, the HTML will not be displayed until the stored program has completed execution.

Preview HTML output

View the translated HTML page in the HTML Viewer

TIP: Use the drag and drop feature as you would for any script development. The Web Server Syntax allows you to drag Web server syntax directly into your script. The results of dragging and dropping syntax into your program are displayed.

Compile and save your script.

Use the Code Editor.

See also Import HTML as PL/SQL for HTML > Stored Procedure.

Related Documents

The document was helpful.

Select Rating

I easily found the information I needed.

Select Rating