Show: Today's Messages :: Unanswered Messages :: Polls :: Message Navigator
3 Search Results Found
1 Forum: SQL & PL/SQL «» Posted on: Tue, 10 December 2013 12:03 «» By: ThomasG
Re: object type
…phone_type as object * ERROR at line 1: ORA-02303: cannot drop or replace a type with type or table dependents So FORGET about objects for now. Completely and absolutely. They have some uses in PL/SQL when you create and pass them on the fly, …
2 Forum: SQL & PL/SQL «» Posted on: Wed, 01 February 2012 11:53 «» By: Andrey_R
Re: ORA-02303: cannot drop or replace a type with type or table dependents
…my example i know how it's called, but in my real problem - i only get the error ora-02303 and don't know which objects are depandant and therefore could be affected, and should be handled. can you shed some light on this? Thank you, Andrey…
3 Forum: SQL & PL/SQL «» Posted on: Wed, 01 February 2012 05:00 «» By: Andrey_R
ORA-02303: cannot drop or replace a type with type or table dependents
…or replace a type. i get this error: ORA-02303: cannot drop or replace a type with type or table dependents SQL> SQL> --create a test user: SQL> SQL> create user tuser identified by tuser 2 / User created. SQL&…

Current Time: Mon Jan 27 03:44:21 CST 2020