From oracle-l-bounce@freelists.org Fri May 13 09:29:19 2005 Return-Path: Received: from air891.startdedicated.com (root@localhost) by orafaq.com (8.12.10/8.12.10) with ESMTP id j4DET4n8022261 for ; Fri, 13 May 2005 09:29:09 -0500 X-ClientAddr: 206.53.239.180 Received: from turing.freelists.org (freelists-180.iquest.net [206.53.239.180]) by air891.startdedicated.com (8.12.10/8.12.10) with ESMTP id j4DET44Z022245 for ; Fri, 13 May 2005 09:29:04 -0500 Received: from localhost (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id F3459192DC6; Fri, 13 May 2005 08:26:14 -0500 (EST) Received: from turing.freelists.org ([127.0.0.1]) by localhost (turing [127.0.0.1]) (amavisd-new, port 10024) with ESMTP id 28656-08; Fri, 13 May 2005 08:26:14 -0500 (EST) Received: from turing (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 7554A192C11; Fri, 13 May 2005 08:26:14 -0500 (EST) From: Katz.C@forces.gc.ca To: rgramolini@tax.state.vt.us, oracle-l@freelists.org Subject: RE: force a title to print in sqlplus Date: Fri, 13 May 2005 09:24:20 -0400 MIME-Version: 1.0 Content-type: text/plain; charset=iso-8859-1 Message-Id: <20050513131927.7C99482585@mx01.forces.gc.ca> Content-Transfer-Encoding: 8bit X-archive-position: 19662 X-ecartis-version: Ecartis v1.0.0 Sender: oracle-l-bounce@freelists.org Errors-To: oracle-l-bounce@freelists.org X-original-sender: Katz.C@forces.gc.ca Precedence: normal Reply-To: Katz.C@forces.gc.ca X-list: oracle-l X-Virus-Scanned: by amavisd-new-20030616-p9 (Debian) at avenirtech.net X-Spam-Level: X-Spam-Checker-Version: SpamAssassin 2.63 (2004-01-11) on air891.startdedicated.com X-Spam-Status: No, hits=0.3 required=5.0 tests=NO_REAL_NAME autolearn=no version=2.63 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@freelists.org [mailto:oracle-l-bounce@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