g_header_html VARCHAR2(4000) := '<html xmlns:v="urn:schemas-microsoft-com:vml" xmlns:o="urn:schemas-microsoft-com:office:office" xmlns:x="urn:schemas-microsoft-com:office:excel" > <head> <meta http-equiv="Content-Type" content="text/html; charset=GB2312" /> <title> 物料搬运单卸货LPN </title> </head> <body> <table border="0" width="100%" > <tr> <td><b>物料搬运单卸货LPN </b></td> </tr> <tr> <td><b> </b></td> </tr> </table> <table border="1" cellspacing=1> <tr> <td>物料搬运单编号</td> <td>行号</td> <td>任务状态标识</td> <td>卸货LPN</td> <td>物料/说明</td> <td>来源子库存</td> <td>来源货位</td> <td>目标子库存</td> <td>目标货位</td> <td>单位</td> <td>数量</td> </tr>'; g_data_html VARCHAR2(4000) := '<tr> <td>C_A</td> <td>C_B</td> <td>C_C</td> <td>C_D</td> <td>C_E</td> <td>C_F</td> <td>C_G</td> <td>C_H</td> <td>C_I</td> <td>C_J</td> <td>C_K</td> </tr>'; g_footer_html VARCHAR2(4000) := '</table></body></html>';
--使用:
g_header_html := REPLACE(g_header_html, 'T1', l_org_info);