Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.tools -> can't local data into a table in oracle 8i lite for NT

can't local data into a table in oracle 8i lite for NT

From: George Thompson <george_at_georgio.demon.co.uk>
Date: Mon, 27 Nov 2000 11:49:19 -0000
Message-ID: <cLtU5.10$DF5.317@news2-hme0>

This happens when I try to load data into a table in 8i for nt. I 'm connectes as system connect string ODBC:POLITE:test_db

George

Connected to:
Oracle Open Client Adapter for ODBC 6.0.5.3.0 Oracle Lite ORDBMS 4.0.0.2.0

SQL> describe table1

 Name                            Null?    Type
 ------------------------------- -------- ----
 NAME                                     VARCHAR2(10)
 ADDRESS                                  VARCHAR2(10)

SQL> INSERT into table1
  2 ( NAME, ADDRESS )
  3 values(me, somewhere);
INSERT into table1
*
ERROR at line 1:
OCA-30035: column not found
[POL-5205] column not found

SQL> Received on Mon Nov 27 2000 - 05:49:19 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US