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

[Quoted] 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.