Hi,
I am having problem using css code in my PL/SQL procedure. My question is how can I use css code in my procedure?Thanks..
My code is below:
create or replace procedure new_menu(xfolder varchar2) is
TYPE GenericCurTyp IS REF CURSOR;
F_TABLE GenericCurTyp;
F_TABLE2 GenericCurTyp;
x varchar2(200);
y varchar2(40);
begin
htp.p(‘<head>
<!DOCTYPE html PUBLIC “-//W3C//DTD XHTML 1.0 Strict//EN”>
<style type=”text/css”>
a {color:#000;}
a:hover {text-decoration:none;}
a:visited {color:#000;}
.photo {width:635px; text-align:left; position:relative; margin:0 auto;}
.photo ul.topic {padding:0; margin:0; list-style:none; width:635px; height:auto; position:relative; z-index:10;}
.photo ul.topic li {display:block; width:125px; height:31px; float:left;}
.photo ul.topic li a.set {display:block; font-size:11px; width:124px; height:30px; text-align:center; line-height:30px; color:#000; text-decoration:none; border:1px solid #fff; border-width:1px 1px 0 0; background:#ccc; font-family:verdana, arial, sans-serif;}
.photo ul.topic li a ul,
.photo ul.topic li ul
{display:none;}
.photo ul.topic li a:hover,
.photo ul.topic li:hover a
{color:#fff; background:#aaa;}
.photo ul.topic li a:hover ul,
.photo ul.topic li:hover ul
{display:block; position:absolute; left:0; top:31px; list-style:none; padding:0; margin:0; height:175px; background:#ddd; width:464px; padding:40px 60px; border:20px solid #aaa; z-index:100;}
</style></head><body>’);
htp.p(‘<div class=”photo”>’);
htp.p(‘<ul class=”topic”>’);
htp.p(‘<table>’);
OPEN F_TABLE FOR SELECT a, b FROM table1 WHERE parent_item = xfolder;
loop
FETCH F_TABLE INTO x,y;
exit when F_table%NOTFOUND;
htp.p(‘<tr>’);
htp.p(‘<ul>’);
htp.p(‘<!–[if lte IE 6]><table><tr><td><![endif]–>’);
htp.p(‘<tr><td class=”item”><b>’||x||'</td></tr>’);
htp.p(‘</ul>’);
htp.p(‘<!–[if lte IE 6]></td></tr></table></a><![endif]–>’);
htp.p(‘</li>’);
htp.p(‘</tr>’);
end loop;
close f_table;
htp.p(‘</table>’);
htp.p(‘</ul>’);
htp.p(‘<br class=”clear” />’);
htp.p(‘</div>’);
end new_menu;
/
show errors