How can I check a type's dependents order to drop them and replace/modify the initial type?
Posted
by pctroll
on Stack Overflow
See other posts from Stack Overflow
or by pctroll
Published on 2010-04-12T19:51:33Z
Indexed on
2010/04/12
19:52 UTC
Read the original article
Hit count: 270
I tried to modify a type using the following code and it gave me the error code: 'ORA-02303'. I don't know much about Oracle or PL/SQL but I need to solve this; so I'd appreciate any further help with this.
Thanks in advance. The code is just an example. But then again, I need to check its dependents first.
create or replace type A as object (
x_ number,
y_ varchar2(10),
member procedure to_upper
);
/
© Stack Overflow or respective owner
