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
Another thing why you shouldn't use Types. Let's consider you where really stupid enough to do this: create or replace type phone_type as object (phone_number number(10), phone_class char(1) ) ; / CREATE TABLE phones (col phone_type); ...
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
Thanks for replying. I didn't understand how i can find the table or object which is depandant on my type in DBA_DEPENDENCIES. in 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 ...
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
Hi all, i am trying to run a script in which a command tries to create 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>...

Current Time: Wed Jun 19 08:19:16 CDT 2019