Re: Merging Html and output from a SQL Querry On WebServer 2.1
Date: 1997/10/09
Message-ID: <343d12d9.14894667_at_newshost>#1/1
You can take a look at the owa replacement cartridge (freeware, source code and binary, use at own risk sort of deal) on http://govt.us.oracle.com/ under downloadable utilities. It'll let you embed PL/SQL in html, for example:
<html> <head> <title>Hello</hello> </head> <body>
this is some text, lots of stuff here <img src=foo.gif>
...
...
<oracle>
begin
some_procedure( :n );
end;
</oracle>
here is more text....
<table> <tr><th>Ename</th><th>Job</th></tr> <oracle>
begin
owa_util.cellsprint( 'select ename, job from emp where ename like :ename' );
end;
</oracle>
</table>
here is yet more...
<oracle>
declare
l_str varchar2(25);
begin
select to_char( sysdate, 'dd-mon-yyyy hh24:mi:ss' ) into l_str from dual;
htp.bold( 'The time is ' || l_str );
end;
</oracle>
On Wed, 08 Oct 1997 11:05:07 GMT, nsi_at_tornado.be (Massimo Trento) wrote:
>
>
>Hello.
>
>I have a client that needs to include in his own designed html pages,
>the output of a PL/SQL function.(This is a result from a submitted
>form)
>
>For this , i need to load the Html page , execute the querry , insert
>the result in the loaded page and the print the page.
>But the problem is that i did not find any way to load the html from
>the disk (not the database).
>
>The possible solutions i found are :
> - Using Live Html, using the commands : <--#config cmdecho='ON'>
> <--#exec MySqlFunction >
>
> and hoping that the result will be merged with the current page
> (according to the Oracle Tech. support, it is not possible.
>
> - Writing my own WRB cartridge to load the page, modify it and
> then printing the page+result merged alltogether.
>
>Has anyone managed to do such a thing ?
>
>Solutions are welcome
>
>The running platform is Windows NT4 Server + Oracle WebServer 2.1
>
>Thanx in advance.
>
>p.s. : Please reply also by mail , because i do not check the
>newsgroups on a daily basis.
>
>Massimo Trento
>nsi_at_tornado.be
>
Thomas Kyte
tkyte_at_us.oracle.com
Oracle Government
Bethesda MD
http://govt.us.oracle.com/ -- downloadable utilities
Opinions are mine and do not necessarily reflect those of Oracle Corporation Received on Thu Oct 09 1997 - 00:00:00 CEST