Newbie: migrating a .sql file to a procedure
Hi,
Im trying to migrate a report which runs on a local server.
This is the beginning of the report:
set termout off
alter session set nls_date_format = 'YYYY-MM-DD';
set pagesize 5000
set feed off
set markup HTML ON HEAD " -
<style type='text/css'> -
body {font:10pt Arial,Helvetica,sans-serif; color:black; background:White;} -
p { font:10pt Arial,Helvetica,sans-serif; color:black; background:White;} -
table,tr,td {font:10pt Arial,Helvetica,sans-serif; color:Black; background:#f7f7e7; -
padding:0px 0px 0px 0px; margin:0px 0px 0px 0px; white-space:nowrap;} -
th { font:bold 10pt Arial,Helvetica,sans-serif; color:#336699; background:#cccc99; -