cleanning sqlplus query [message #304956] |
Fri, 07 March 2008 05:28  |
viko
Messages: 9 Registered: March 2008
|
Junior Member |
|
|
Hi
I'm launching this query (and many others) inside a script.
But I'm receiving an undesired "Press <Enter>" line in my result.
I've tried the query outside that script and that line does not appear.
but inside the script does, and always. I actually have tried getting it out from the function, and modifing it indentation. But I receive that line anyway.
function get_host ( ) {
sqlplus -s usr/pass << PSQL2
SET HEADING OFF
SET LINESIZE 200
SET PAGESIZE 50000
SELECT maquina FROM table@host WHERE field=$3 AND field=$4
;
PSQL2
}
|
|
|
|
|