SQL Navigator for Oracle 7.5

Converse agora com nosso suporte

Obtenha ajuda em tempo real
Concluir registro

Entrar

Solicitar preços

Entre em contato com o setor de vendas

New Features Resolved Issues Known Issues System Requirements Product Licensing Getting Started with SQL Navigator 7.5 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;

Selecione seu produto:

Para podermos atendê-lo melhor, informe o Propósito de seu chat:

Soluções recomendadas para seu problema

SQL Navigator for Oracle 7.5 - Release Notes

Import HTML as PL/SQL

Sample code for displaying query results in a HTML page