html - 从 PL/SQL 生成 HTML

Question

CREATE OR replace PROCEDURE Hello_world2
IS
BEGIN
    HTP.htmlopen;
    HTP.headopen;
    HTP.Title ('You knew it was coming...');
    HTP.headclose;
    HTP.comment ('This phrase is in every computer book.');
    HTP.Bodyopen (cattributes => 'body bgcolor=blue');
    HTP.Print ('And here it is .... Hello, World!');
    HTP.bodyclose;
    HTP.htmlclose;
END; 

如何将其输出到 HTML 文件？我试过如下所示:

spool report.htm
exec hello_world2;
spool off
exit

但是我得到如下所示的错误:

    ORA-06502: PL/SQL: numeric or value error
    ORA-06512: at "SYS.OWA_UTIL", line 356
    ORA-06512: at "SYS.HTP", line 1368
    ORA-06512: at "SYS.HTP", line 1443
    ORA-06512: at "SYS.HTP", line 1735
    ORA-06512: at "SYS.HTP", line 72
    ORA-06512: at "T416493.HELLO_WORLD2", line 4
    ORA-06512: at line 1

谁能帮我解决这个问题

Answer 1

通常您会调用 owa_util.showpage 来假脱机显示内容。Dan 对用法有很好的概述 Oracle OWA_UTIL这有一些有趣的地方，它应该从 sqlplus 运行，但我认为它应该使用网络浏览器从 mod_plsql 调用。

如果你真的只想生成静态网页，你也可以使用普通的旧 dbms_output 来做到这一点。否则，看看 Oracle Apex 可能更聪明或者甚至 a very nice and capable alternative for Oracle Apex, Formspider