Re: webdb PLSQL

You should examine the package called "HTP". It has a number of routines that encapsulate HTML almost entirely. I find the most useful htp.print procedure. Here is an example:

<ORACLE>

declare
 cursor c_emp is
  select ename, sal
  from scott.emp;
begin
 for tmp in c_emp loop
   if sal > 10000 then
     htp.print('<font color="red">'||tmp.ename||'</font><br>');    else
     htp.print('<font color="green">'||tmp.ename||'</font><br>');    end if;
 end loop;
end;
</ORACLE>

That's it - give it a try.

• Sent from RemarQ http://www.remarq.com The Internet's Discussion Network * The fastest and easiest way to search and participate in Usenet - Free!