Re: oracle job

[Igor Neyman]

I don't think, that job calling stored procedure from the package gets invalidated (at least according to my experience: I was recompiling packages and didn't have anything to do with the jobs calling stored procedures from recompiled packages, unless call to the stored procedure changed, like new or different types of parameters passed to stored procedure). The only issue here: make sure, that job is not running, when you are recompiling the package.   Igor Neyman, OCP DBA [EMAIL PROTECTED]       ----- Original Message ----- From: Jamadagni, Rajendra To: Multiple recipients of list ORACLE-L Sent: Friday, March 28, 2003 11:43 AM Subject: RE: oracle job if you compile package spec, then all dependent objects will be invalid, if you compile package body, then there will be no invalids.   Raj ------------------------------------------------------------- Rajendra dot Jamadagni at espn dot com Any views expressed here are strictly personal. QOTD: Any clod can have facts, having an opinion is an art !! -----Original Message----- From: AK [mailto:[EMAIL PROTECTED] Sent: Friday, March 28, 2003 11:04 AM To: Multiple recipients of list ORACLE-L Subject: Re: oracle job 8.1.6   -ak ----- Original Message ----- From: Jamadagni, Rajendra To: Multiple recipients of list ORACLE-L Sent: Thursday, March 27, 2003 3:28 PM Subject: RE: oracle job Which version "rubs" the job? -----Original Message----- From: AK [mailto:[EMAIL PROTECTED] Sent: Thursday, March 27, 2003 2:29 PM To: Multiple recipients of list ORACLE-L Subject: oracle job If the package which is going to be rub by oracle job gets compiled , does it invalids the job also ?   thanks, -ak