sqlplus: chr(10) in sqlprompt?

From: Chuck <skilover_nospam_at_softhome.net>
Date: Mon, 13 Jun 2005 16:02:01 -0400
Message-ID: <1118688897.e3945db861e2a6a41fb703f1c475cc3f_at_bubbanews>

[Quoted] Is there a way to set the sqlprompt to something like '<DONE>'||chr(10)?

I want to write a korn shell script that runs sqlplus as a coprocess and  use something like <DONE> as a code to indicate that query output is finished and it's waiting for another command. Problem is the sqlprompt variable doesn't seem to let me put a newline at the end so I can read it as a complete line from the coprocesses.

Thanks.

-- 
To reply by email remove "_nospam"

Received on Mon Jun 13 2005 - 22:02:01 CEST