Home » SQL & PL/SQL » Client Tools » cleanning sqlplus query
cleanning sqlplus query [message #304956] Fri, 07 March 2008 05:28 Go to next message
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
}
Re: cleanning sqlplus query [message #304961 is a reply to message #304956] Fri, 07 March 2008 05:58 Go to previous messageGo to next message
Michel Cadot
Messages: 64111
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator

set pause off

Regards
Michel

[Updated on: Fri, 07 March 2008 06:00]

Report message to a moderator

Re: cleanning sqlplus query [message #304992 is a reply to message #304961] Fri, 07 March 2008 07:44 Go to previous message
viko
Messages: 9
Registered: March 2008
Junior Member
work's great

thanks a lot
Previous Topic: Access violation
Next Topic: ISqlPlus
Goto Forum:
  


Current Time: Mon Dec 05 15:08:47 CST 2016

Total time taken to generate the page: 0.09719 seconds