Skip to Main Content

SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Not able to Drop the Table Type

user2626293Apr 16 2013 — edited Apr 16 2013
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;
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on May 14 2013
Added on Apr 16 2013
2 comments
231 views