Error: FRM-40505: Oracle error: unable to perform query (due to no such object).

Message

FRM-40505: Oracle error: unable to perform query.

Cause of Error

This behavior occurs because the object that you tried to use does not exist in the database.

Solution Summary

Create the necessary object, and then run the form again to perform the query.

Solution Details

NOTE: To perform the following procedure, you must have sufficient account privileges to access the appropriate database and to create tables, views, or synonyms in the database.

1) If you have not already done so, start SQL*Plus 8.0, and then log on to the appropriate database.
2) Do one of the following as appropriate:

NOTE: Be sure to end the command with a semicolon (;).
a) To create the necessary table, type the following command at the SQL*Plus prompt and then press ENTER:
CREATE TABLE (
,
,
);
where

is the name of the table you want to create, through are the names of the columns you want to create in the table, and is the datatype for a specific column.

NOTE 1: For some datatypes, such as CHAR, VARCHAR2, or NUMBER, you need to specify the width or precision of values. Also, you can add constraints for the table or for a specific column. For example, you can specify the primary key for the table; you can also specify the NOT NULL constraint for a column, which means that you must enter a value for that column when you add a row to the table.

NOTE 2: To be able to create a view, your account must also have the privileges to retrieve data from the table or tables you want to use in the view.
b) To create the appropriate view, type the following command and then press ENTER:
CREATE VIEW
(, ...)

AS
;
where is the name of the view that you want to create, through are the names of the columns that you want to include in the view, and is the SELECT query that retrieves data from the appropriate table or tables.
c) To create the appropriate synonym, do one of the following:
1] To create a private synonym, type the following command, and then press ENTER:
CREATE SYNONYM
FOR .

;
where is the alternate name for the table, is the user name of the table owner, and

is the name of the table for which you want to create a private synonym.
2] To create a public synonym, type the following command, and then press ENTER:

NOTE: Usually, your account must have database administrator privileges to create public synonyms.
CREATE PUBLIC SYNONYM
FOR .

;
where is the alternate name for the table, is the user name of the table owner, and

is the name of the table for which you want to create a public synonym.
3) Run the form again to perform the query.

Applies to Software Version

Oracle8