Re: Can a Table be Invalidated?

In message <1121602512.708610_at_yasure>, DA Morgan <damorgan_at_psoug.org> writes
>Jim Smith wrote:
>
>>> desc user_tables
>>>
>>> you don't see a STATUS column.
>>>
>>>
>> Good point. You could have said that instead of your typical "how
>>dare you post to this group in ways I don't like" response.
>
>I wasn't trying to be an arrogant SOB: Never am. But part of teaching
>at the university level is teaching students to find the answers
>themselves and not rely on an instructor/professor.
>
>Thus when something is easily proven by trial or reading I always try
>to point in that direction.

But you are not teaching at a university level. You are taking part in a cooperative discussion group. You seem to assume that everything posted is some business critical piece of research. I was just joining in a conversation with what seemed a reasonable question. I don't use object types so I haven't read those bits of the manual closely (or at all in some cases)
>
>>
>>> SQL> CREATE OR REPLACE TYPE CourseList AS TABLE OF VARCHAR2(90000);
>>> 2 /
>>> CREATE OR REPLACE TYPE CourseList AS TABLE OF VARCHAR2(90000);
>>> *
>>> ERROR at line 1:
>>> ORA-02303: cannot drop or replace a type with type or table dependents
>> Not sure this entirely answers my question. If you have an object
>>type with code attached and somewhere down the code dependency tree a
>>procedure becomes invalid, what happens? Or does 2303 imply you can't
>>change the procedure because a table depends on it?
>
>Does more than imply it ... it proves it AFAIK. If you think it is
>possible for this to happen then, referring to my response above, come
>up with the scenario and try it. I did and you've seen my results.
>
>> I suppose I need to go and investigate. And then never tell anyone
>>because they can always find out for themselves.
>
>My point remains that if you think it is possible to attach some form
>of PL/SQL to a table in such a manner that it might become invalid and
>thus invalidate the table ... that you do it. Because I can think of
>no possible scenarios other than the three I showed you.
>

None of your scenarios have code attached. However, assuming what you say is true, that means that using object types makes your database code maintenance hugely difficult. Instead of just create or replace on the pl/sql you have to drop and recreate the table, including managing any existing data.

>>> I was not trying to be obnoxious.
>> You don't have to try, for some people it seems to come naturally
>
>And for some people it comes naturally to be offended when an answer
>is not spoon fed to them. And for some people it comes naturally to
>expect others that donate their time, for free, to expect certain
>responses.
>

>I challenge you to search these c.d.o. usenet groups and compare the
>number of questions asked to the number of complaints like yours

People don't complain, they just go elsewhere.

>and
>also to the number of times the OP says "Please" and/or "Thank you."
>You should have no problem accurately guessing that a search for either
>phrase will return very few hits. And you don't see us whining about
>being taken for granted or how rude OP's are.
>

You just did.

>We help people because we want to and for no other reason. If you do not
>like the quality, or the quantity, or the manner in which that help is
>offered how is that my, or our, problem?
>

Its your problem because you are the one replying in a bullying manner. I'm not going to sit back and be bullied.

>>> I was trying to point out that in
>>> 10-15 seconds anyone with any amount of curiousity could have answered
>>> the question.
>> As I said in my followup, I wasn't that interested.
>
>You could have said "Thank you" to everyone that jumped in and helped
>you. Not me ... the others. Perhaps I missed that post.

Actually, I haven't read any of the other posts yet. But you are missing the point again. I wasn't asking for help, I was taking part in a conversion.

-- 
Jim Smith
Because of their persistent net abuse, I ignore mail from
these domains (among others) .yahoo.com .hotmail.com .kr .cn .tw
For an explanation see <http://www.jimsmith.demon.co.uk/spam>