Hello,
the Oracle Messages and Codes Manuals says that the error occurs when e.g.
the select statement returns more columns (!) than what has to be inserted.
I checked your example but it looks ok. Maybe you can take a look at that
your self again.
When you use indexes and you try to insert a row that already exists the
error message is different. (Something like "Unique constraint violated".)
That not very much information but maybe it helps you.
Regards
Corinna
Harold Gray <nohgrayspam_at_pcisys.net> wrote in article
<354F6A14.2A184234_at_pcisys.net>...
> The company name column is not a primary key but it has a unique index
> created for it.
> There shouldn't be any duplicates in the name column of company table.
>
> -Harold
>
> Ricardo Patrocínio wrote:
>
> > Is the name field the primary_key, if not are you shure you only have
> > one company named 'companyname'?
>
>
>
>
Received on Thu May 07 1998 - 06:21:25 CDT
