Re: this insert is not working .....

On Mon, 20 Nov 2006 05:10:32 GMT, user <someone_at_someplace.org> wrote:

> com_name varchar2(50) NOT NULL,
> CONSTRAINT cccb_pk PRIMARY KEY (cccb_id));

 The start of this seems to have been cut off.

>insert into cccb values (150 ,'Annexation C');
>insert into cccb values(200 ,'Advisory C');
>insert into cccb values(800 ,'Protection C');
>insert into cccb values(1000 ,'Transit C');
>insert into cccb values(1050 ,'Water C');
>
>insert errors out with
>
>ORA-00911: invalid character
>
>any suggestions?

 Copy and paste an example session with the error from SQL*Plus to demonstrate exactly what failed.

-- 
Andy Hassall :: andy@andyh.co.uk :: http://www.andyh.co.uk
http://www.andyhsoftware.co.uk/space :: disk and FTP usage analysis tool