Avoiding spooling to empty files

From: CenturionX <darwinbaldrich_at_gmail.com>
Date: Fri, 30 Jan 2009 12:53:00 -0800 (PST)
Message-ID: <8f918828-28bd-4a64-b017-ce345429f824_at_s20g2000yqh.googlegroups.com>

Hello,

I'm working with Oracle 10.2.0.4.0

I have an unix script that via command line executes a query

$ORACLE_HOME/bin/sqlplus -silent <<EOF

	connect user/pass_at_databse
	set pagesize 0
	set heading off
	set echo off
	set term off
	set feedback off
	set linesize 126
	spool /tmp/file_to_send
	SELECT * FROM table;

EOF The issue is that if there is not data it generates a file with a control caracter (Don't know which one).

I want to know how to avoid file generation via SQLPLUS commands or at least don't send any invisible caracter to the file.

Thanks. Received on Fri Jan 30 2009 - 14:53:00 CST