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 -> SQLPLUS -ORA-00984 Coumn no allowed here

SQLPLUS -ORA-00984 Coumn no allowed here

From: <ben_knill_at_hotmail.com>
Date: Tue, 03 Apr 2001 15:30:04 -0000
Message-ID: <tcjr3sf0734acd@corp.supernews.com>

Im new to Oracle SQLPLUS and I keep getting this error. The code is:

INSERT INTO customer
(cust_no,cust_name,cust_add_1,cust_add_2,cust_add_city,cust_add_county,cust _postcode,cust_credit)values (&customer_number, &customer_name,
&customer_Address_line_1,&Customer_Address_line_2,&Customer_city,
&Customer_County, &customer_postcode, &Customer_credit);

Firstly, I get a comma missing message on cust_name, after the space. Then I retry, removing the space and then I get the ORA-00984 error message

--
Posted via CNET Help.com
http://www.help.com/
Received on Tue Apr 03 2001 - 10:30:04 CDT

Original text of this message

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