SQL Navigator for Oracle 7.4

Chatee ahora con Soporte

Obtener ayuda en vivo
Completar registro

Iniciar sesión

Solicitar precios

Comuníquese con Ventas

Resolved Issues Known Issues System Requirements Product Licensing Getting Started with SQL Navigator 7.4 Globalization Copyright

Import HTML as PL/SQL

Convert a HTML file into a PL/SQL stored procedure. The stored procedure will in turn output the HTML code via the Oracle Web Toolkit.

Actions	Description
Enable the web server	Select Session \| Capture Web Output.
Open the Code Editor.	Click View \| Code Editor.
New Stored Object	Create a new stored object in the Code Editor. Enter the name and the parent schema of the new procedure.
Import HTML file as PL/SQL	Click Tools \| Import HTML as PL/SQL The import process wraps each line of the imported HTML file inside the htp.print ( … ); markers. PL/SQL statements can be embedded in HTML code inside comments; for example: <!--PLSQL a_random_plsql_statement; --> These comments must start with the string <!--PLSQL and end with --> You can put things in the declaration section of the procedure (to declare a cursor, for example) by ensuring they come first in the file, before the first <HTML> tag. For example: <!—PLSQL CURSOR emp_cur IS SELECT ename FROM emp;
Save the program to the database.	When the HTML is imported into the stored program, you can save the program to the database.

See also HTML Viewer for Stored Procedure > HTML.

Sample code for displaying query results in a HTML page

The following example code will display details from a query in a web browser.

First, create a table named emp with a column ename. Add some data to the ename column, and then run the following procedure with the SQL Navigator Web Development Module enabled.

PROCEDURE PLH_EXAM1 is—this procedure generated from "\\phanevski1\c$\docs\EXEone.HTM".—warning: any changes made to this procedure will not be—reflected in the original HTML file.

CURSOR emp_cur IS

SELECT ename

FROM emp;

begin

htp.print(‘ ‘);

htp.print(‘<HTML>’);

htp.print(‘<HEAD>’);

htp.print(‘<TITLE>Embedded PL/SQL Example</TITLE>’);

htp.print(‘</HEAD>’);

htp.print(‘<BODY>’);

htp.print(‘<H1>Employee Names</H1>’);

htp.print(‘<TABLE>’);

htp.print(‘ ‘);

FOR emp_rec IN emp_cur LOOP

htp.print(‘ <TR>’);

htp.print(‘ <TD>’);

htp.print(emp_rec.ename);

htp.print(‘</TD>’);

htp.print(‘ </TR>’);

htp.print(‘ ‘);

END LOOP;

htp.print(‘</TABLE>’);

htp.print(‘</BODY>’);

htp.print(‘</HTML>’);

end;

Seleccione su producto:

Con el fin de ofrecerle un mejor servicio, complete el campo Motivo del chat:

Soluciones recomendadas para su problema

SQL Navigator for Oracle 7.4 - Release Notes

Import HTML as PL/SQL

Sample code for displaying query results in a HTML page