| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> Re: Database Startup Trigger is not pinning all packages
I would need to double-check on your error, but the usual problem with pinning packages at startup is that they haven't been loaded into memory (standard and some of SYS's other packages load almost at the initial moment of startup). Try to put some code into the trigger to call the packages first, then load them. One approach is to put in dummy function in the user packages that returns null and call that function, thus pulling the package into memory.
Regards,
Chris Gait
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author:
INET: cjgait_at_earthlink.net
Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Lists --------------------------------------------------------------------To REMOVE yourself from this mailing list, send an E-Mail message to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). Received on Mon Feb 12 2001 - 13:26:27 CST
 |
 |