Home » Fusion Middleware & Colab Suite » Weblogic & Application Server » PL/SQL initalize() ?
PL/SQL initalize() ? [message #155222] Thu, 12 January 2006 18:18 Go to next message
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 Go to previous message
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).
Previous Topic: sys.dbms_trace?
Next Topic: OWS log file
Goto Forum:
  


Current Time: Mon Oct 19 10:53:20 CDT 2020