| PL/SQL initalize() ? [message #155222] |
Thu, 12 January 2006 18:18  |
a reader
Messages: 7
Registered: January 2006
|
Junior Member |
|
|
I am looking into creating JAVA-like delgator layer in PL/SQL. For example, the top-layer will call other packages that peform the actual business logic i.e. search, update.
Question: what "things" should I consider while initialzing the top-level package?
For example:
1. check if all low-level packages are compiled and in a good state,
2. check for errors,
3. other?
|
|
|
|
| Re: PL/SQL initalize() ? [message #155633 is a reply to message #155222] |
Tue, 17 January 2006 14:04  |
andrew again
Messages: 2577
Registered: March 2000
|
Senior Member |
|
|
|
Just call it like any other pl/sql pkg, proc, function. It is no different to you calling a Oracle supplied package like dbms_output or whatever. If the code you are calling is invalid, Oracle will try to validate it when you call your wrapper layer (which will also be invalid at that time because it depends on something else which is invalid).
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
