Re: sqlplus: chr(10) in sqlprompt?

[Quoted] "Chuck" <skilover_nospam_at_softhome.net> a écrit dans le message de news:1118688897.e3945db861e2a6a41fb703f1c475cc3f_at_bubbanews...
| 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"

I don't check but this might work:

col myprompt noprint new_value myprompt
select '<DONE>'||chr(10) myprompt from dual; set sqlprompt '&myprompt'

Regards
Michel Cadot Received on Mon Jun 13 2005 - 22:15:40 CEST