Re: SQLPlus Bug???

From: Thomas Bartel <thomas.bartel_at_erlf.siemens.de>
Date: Fri, 01 Oct 1999 16:54:53 +0200
Message-ID: <37F4CB3D.ECA80AA5@erlf.siemens.de>

try this: set description = 'Setup: '||chr(13)||' '||chr(13)||'Step1'|| .....

Chris Forlano wrote:

> I'm trying to send the following SQL through SQLPlus:
>
> update test set description = 'Setup:
>
> Step1
> Step2
>
> Execute.';
>
> I am unable to do this as the SQLPlus prompt will consider the line
> completed
> after two carriage returns. As a result, we cannot insert data into a
> table that contains
> more than one newline through SQLPlus.
> The SVRMGRL on my server does not behave this way ... it behaves
> properly.
>
> Is this a bug in SQLPlus or is there some clever setting I can
> configure?
>
> Thanks,
>
> Chris
>
> --
> Chris Forlano
> Automation Development
> Nortel Networks, Maidenhead
> 590 4342 (01628 434 342)
> cforlano_at_nortelnetworks.com
Received on Fri Oct 01 1999 - 09:54:53 CDT