RE: force a title to print in sqlplus

I think one of the work-arounds was to start each sqlplus report with a call to another script e.g. @setup_script 'message text for users'. The setup script would print the message text even if the sqlplus report returns no rows (The setup script will also print the message text (on the first page of the report) even if the sqlplus report returns rows but since nothing's perfect...
chaim  

-----Original Message-----

From: oracle-l-bounce_at_freelists.org
[mailto:oracle-l-bounce_at_freelists.org]On Behalf Of Ruth Gramolini Sent: Friday, May 13, 2005 9:00 AM
To: oracle-l
Subject: force a title to print in sqlplus

Good morning all,
One of my developers wants to know if there is a way to force the ttitle to print on a report even if no rows are found. Does anyone know how to do this?

You will make me a hero if I get an answer, Ruth

--

http://www.freelists.org/webpage/oracle-l
--

http://www.freelists.org/webpage/oracle-l Received on Fri May 13 2005 - 09:29:19 CDT