Re: True novice doubt SQL*Forms 3.0...

In article <1992Mar17.043828.28863_at_ra.msstate.edu> sk3_at_ra.msstate.edu (Sudhir Kolli) writes:

> I am a novice to SQL*Forms 3.0 designing.
 

> Enter the form name I want to create in the dialog box..
> Now!! I am getting the error message
> "ORA 00942: Table or view doesn't exist."
 

> Thanks.
 

> -Sudhir Kolli.
 

> sk3_at_ra.msstate.edu

The table in question is not YOUR table; it's the tables and views of the SQL Forms extended data dictionary.

When you install Forms, you need to run a SQL script that creates the tables, and public views on those tables. If you're getting this error, then my first guess is that Forms was not installed correctly, or at least that the SQL script was not run.

If you get the same error when logged in as SYSTEM, the SQL script definitely needs to be run. If you do NOT get the error when logged in as SYSTEM, then your user needs to be able to see the Forms views. Consult your installation manual on this one.

(I'm posting this because the problem is a pretty common one for beginners; I think it'll want to go into the FAQ for Forms. Anybody want to volunteer to compile it?)

Cheers.

-- 
Thomas Cox   (I work for Oracle, so I can't be considered impartial.)
tcox_at_us.oracle.com				work: 503-220-1678