I can see how this could work. Thanks for the direction. I'll explore it.
Chunning" wrote:
>
> You can not do it in DBI.
>
> Use
>
> $sql = "SELECT * from dual;";
> open ORA, "| /opt/oracle/product/8.1.7/bin/sqlplus -s
> $name/$passwd " or die "Can't pipe to sqlplus: $!";
> print ORA "set pagesize 0 linesize 120 termout off\n";
> print ORA "set feedback off\n";
> print ORA "spool $file_name;\n";
> print ORA "$sql\n";
> print ORA "exit\n";
> close ORA;
> system ("gzip -f $file_name");
>
> Good luck
>
> cs
>
> -----Original Message-----
> From: Ian Harisay [mailto:[EMAIL PROTECTED]]
> Sent: Wednesday, April 17, 2002 4:22 PM
> To: [EMAIL PROTECTED]
> Subject: report formatting
>
> Can anyone point me in the right direction for writing somewhat complex
> reports. Something akin to the report writing capabilities of sqlplus.
>
> Thanks,
>
> Ian
