Question:
I write packages and procedures in both Oracle Database and Oracle Developer applications (Oracle Forms). How should I decide where to put my code?
Answer:
This question was answered in the January/February 2007 issue of Oracle Magazine.
Another way to frame this question is to ask what the scope of your program should be. That is, from which programs in your application can it be called? Within just a single form? All forms? From within a single program on the server? From any schema that connects to your instance?
I make my decision on these issues by following this principle: Implement the program as closely as possible to where it is used (called).
No comments:
Post a Comment