Re: INSERT INTO

From: Wazusa Blong <fitzjarrell_at_cox.net>
Date: Thu, 07 Jun 2007 05:49:22 -0700
Message-ID: <1181220562.942109.147510@g4g2000hsf.googlegroups.com>

On Jun 7, 7:36 am, colmkav <colmj..._at_yahoo.co.uk> wrote:
> Anyone know why this code gets an error "ORA-00911: invalid
> character"?
>
> INSERT INTO ta_tmp(description)
> SELECT DISTINCT description
> FROM t_exposuretype
> WHERE description not in (select description from
> ta_exposuretype);
>
> The Select part works fine.

Have you retyped the query? Don't 'copy and paste', take the time to actually retype the entire statement. You *may* have a 'hidden' control charcter somewhere causing your error.

David Fitzjarrell Received on Thu Jun 07 2007 - 07:49:22 CDT