Insert failure

From: Norman Dunbar <Norman.Dunbar_at_lfs.co.uk>
Date: Wed, 23 Oct 2002 11:02:05 +0100
Message-ID: <E2F6A70FE45242488C865C3BC1245DA702D3DDB4@lnewton.leeds.lfs.co.uk>

'set scan off' in sqlplus does the job. Not sure about SQLLoader - as I don't use it myself (yet).

SQL> create table test (a varchar2(100)); Table created.

SQL> set scan on
SQL> insert into test values ('Hello & goodbye'); Enter value for goodbye:
old 1: insert into test values ('Hello & goodbye') new 1: insert into test values ('Hello ') 1 row created.

SQL> set scan off
SQL> r
  1* insert into test values ('Hello & goodbye') 1 row created.

SQL> select * from test;

A

---

Hello
Hello & goodbye

So the poster who 'just pressed enter' (Alistair) may well have inserted truncated data into his table :o(
as can be seen from the select above.

Cheers,
Norman.

---

Norman Dunbar
Database/Unix administrator
Lynx Financial Systems Ltd.
mailto:Norman.Dunbar_at_LFS.co.uk

Tel: 0113 289 6265
Fax: 0113 289 3146
URL: http://www.Lynx-FS.com


-------------------------------------

Received on Wed Oct 23 2002 - 05:02:05 CDT