Re: SQLPLUS -ORA-00984 Coumn no allowed here

From: nick <nick-love_at_juno.com>
Date: Tue, 03 Apr 2001 20:30:11 -0000
Message-ID: <tckcmjhm55rd2c@corp.supernews.com>

ben_knill wrote:
>
> 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/

  If the customer_name,address_line1,address_line, and the rest of the columns are VARCHAR then you would have to put them within the singel quote.... Ex: insert into customer

                values

(&customer_number,'&customer_name','&customer_address_1');

--
Posted via CNET Help.com
http://www.help.com/

Received on Tue Apr 03 2001 - 15:30:11 CDT