Re: Designer/2000: ORA-942/CGEN-1246 on Default Where Clause on Generate

Thanks for the reply Simon - we do not have the destination schema active in the repository instance. One other point which does cause a failure to generate. The statement on derived items ie/: COMPLEX:do_key('NEXT_BLOCK'); also cause ORA-942 errors in some Designer Applications and not others, which leads me to believe a preference may be set for server validation.
Regards,

           Eric

Simon Stow wrote:
>
> The generator attempts to validate the SQL it is generating by
> using the RDBMS to parse it. So in this case it is firing off a
> SQL statement with your table name and where clause in it to
> check that the where clause is valid for that table.
>
> If you don't have the table in the same user, or accessible from,
> the Designer/2000 user then you'll get this warning from the generator.
>
> If you are confident that your where clause is OK you can ignore it.
>
> Eric Keen wrote:
> >
> > During 1.3.2 generate the log produces:
> >
> > SELECT 1 FROM TABLE
> > ERROR at line 1:
> > ORA-00942: table or view does not exist
> >
> > This only happens with a WHERE clause, and we never Compile or Run from
> > Designer.
> > Has anyone experienced this behavior or know how to correct it?
> > Thanks,
> > Eric
> >
> > --
> >
> > Only 612 days left to stock up on canned goods and ammo before
> > 01-JAN-2000
>
> --
>
> The statements and opinions expressed here are my own and
> do not necessarily represent those of Oracle Corporation.

-- 

Only 611 days left to stock up on canned goods and ammo before
01-JAN-2000