Skip to Main Content

SQL Developer

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!

Debug/run procedures within package

Earl LewisOct 29 2015 — edited Oct 30 2015

Debugging in SQL Developer has generally been very nice and I have come to depend on those tools. Today I wrote a procedure within a package and I want to debug that procedure, but I don't see it in the list of targets. It seems that i'm only seeing functions in the target list. I understand that procedures don't have the same kind of output as functions, but occasionally I like to create procedures that have multiple OUT parameters, especially when it's a very closely related output.

The interesting thing is that I can create this very same procedure as a standalone procedure and the run/debug works just fine. Apparently I'm missing something obvious in SQL Developer somewhere. I thought this was there a while ago (I guess it's been a little while since I wrote a procedure with OUT parameters) but maybe I'm mistaken. Any ideas or help anyone?

Earl

This post has been answered by thatJeffSmith-Oracle on Oct 30 2015
Jump to Answer

Comments

NickR2600-Oracle

So when would it be beneficial to have an abstract method in a super class? One answer would be because the sub classes have no shared functionality. Or in other words, because the functionality is so different between subclasses. Or because the functionality can't be defined yet.

In Java Puzzle Ball, I have an abstract class called GameObject. It's inherited by a lot of different concrete classes: bumpers, assignable behaviors, level geometry... And one if its responsibilities is to define what happens when a collision occurs. But I have to leave the collision effect method abstract. The geometry of all these objects are so dramatically different, there isn't any shared functionality I can write to define how the physics of all these different angles and shapes should work. The best I can do is write an abstract method as a promise to implement the functionality somewhere later down the inheritance structure.

pastedImage_0.png

AjayKumarGuttikonda

Thank you so much for taking time out and answering the question in very elaborated manner. I understand, the conclusion is Account class need not be abstract as all methods are implemented and also there is no problem Account class being abstract as the abstract class by definition can have all methods implemented. Can you please also explain why in this case it is beneficial to have Account class as abstract since we have implemented all methods.

NickR2600-Oracle

You got it.  I'm glad you're enjoying the course

It's more of a design choice in this example.  Even though Account could technically exist as a concrete class, I only meant for it to be a container for all the fields and methods shared by savings and checking accounts.  So to reinforce that decision and prevent instances of Accounts from getting created, the class is left abstract.

One other thing to consider is that Accounts don't have an accountType field, but savings and checking account classes do.  Looking back, maybe I should have written an abstract method into the Account class to somehow enforce the need for this field.

1 - 3
Locked Post
New comments cannot be posted to this locked post.

Post Details

Locked on Nov 27 2015
Added on Oct 29 2015
2 comments
559 views