Eventually I want to break this up and generate a "proper" report.
Meanwhile I need a temporary solution, is there any ODAC component than can achieve this? I did have a look, but not sure what I should be looking for..
A typical and very much simplified, example would be - the main select-from-tables repeated about 10 times for different queries with different result sets:
Code: Select all
SET FEEDBACK OFF
SET SPACE 1
SET ECHO OFF
SPOOL FILENAME
SET HEADING OFF
SELECT ' ' FROM DUAL;
SELECT 'Section header' FROM DUAL;
SET HEADING ON
SELECT Audkenni, Texti FROM Daemi;
SPOOL OFF
I have tried a few "workarounds" but there is always something.