Well,
I see one reason ... (I am no expert in Oracle reports), but it seems more maintainable to write in SQR than in reports (so they claim here). Plus SQR can act asa glorified data loader when a bunch of processing needs to be done on incoming raw data.
I wouldn't discount SQR right away, but after all it is almost glorified COBOL (IMHO).
Doing dynamic SQL is much much easier in SQR than in Oracle Reports (again my experience SQR 4/5/6 and ORacle Reports 6/6i). SQRs use of lookup tables and breaks make life simpler as well. It has usable array interface ... for data processing. We have couple of SQR reports that run in about 4000 lines of code (don't ask me why)
My $0.01
Raj
______________________________________________________
Rajendra Jamadagni MIS, ESPN Inc.
Rajendra dot Jamadagni at ESPN dot com
Any opinion expressed here is personal and doesn't reflect that of ESPN Inc.
QOTD: Any clod can have facts, but having an opinion is an art!
-----Original Message-----
From: Jared Still [mailto:[EMAIL PROTECTED]]
Sent: Friday, February 14, 2003 10:09 AM
To: Multiple recipients of list ORACLE-L
Subject: Re: {SPAM?} RE: Teradata baned from IOUG???
We looked at SQR in 94.
We didn't have need of controlling fonts and such, which I guess
SQR is good at.
The SQR rep could come up with no compelling reason to use SQR
rather than Perl, so simple ( as in not much procedural processing
needed ) reports were done in Sqlplus. Anything complex was done
in Perl.
We never regretted that decision.
Jared
*********************************************************************This e-mail message is confidential, intended only for the named recipient(s) above and may contain information that is privileged, attorney work product or exempt from disclosure under applicable law. If you have received this message in error, or are not the named recipient(s), please immediately notify corporate MIS at (860) 766-2000 and delete this e-mail message from your computer, Thank you.*********************************************************************1
