Hello,
I would like to generate SQL queries results into HTML file with PL/SQL program... so I developped the script below .... But it's not working ☹️ ... Any one know how to do that?
declare
html_file utl_file.file_type;
re clob;
begin
html_file:=utl_file.fopen ('TEST_DIR', 'html_test.html', 'W');
SELECT '<HTML>
<title> Database Parameter </title>
<table cols="3" border=2>
<tr><th>Param_Name</th><th>Param_Value</th></tr>
<tr><td> '||name||' </td><td> ' ||value||' </td></tr>
</table>
</HTML>' into re
FROM v$parameter
where name in ('spfile','controle_files','instance_name';
utl_file.put_line(html_file,re );
end;
Thank you.