Hi All,
Database Version:11.2.0.3.0
I have created the below objects, when i am trying to drop the serial_part_tab table it gives me the below error
DROP TYPE apps.SERIAL_PART_TAB;
Error report:
SQL Error: ORA-04043: object SERIAL_PART_TAB does not exist
04043. 00000 - "object %s does not exist"
*Cause: An object name was specified that was not recognized by the system.
There are several possible causes:
- An invalid name for a table, view, sequence, procedure, function,
package, or package body was entered. Since the system could not
recognize the invalid name, it responded with the message that the
named object does not exist.
- An attempt was made to rename an index or a cluster, or some
other object that cannot be renamed.
*Action: Check the spelling of the named object and rerun the code. (Valid
names of tables, views, functions, etc. can be listed by querying
the data dictionary.)
CREATE TYPE serial_part_typ AS OBJECT
(serial_number VARCHAR2(100)
,product_number VARCHAR2(100)
,return_message VARCHAR2(500)
,return_status NUMBER
);
CREATE TABLE serial_part_tab OF serial_part_typ;