Oracle-L: Re: oracle job

From: Igor Neyman <ineyman_at_perceptron.com>
Date: Fri, 28 Mar 2003 09:23:39 -0800
Message-ID: <F001.005755DE.20030328092339@fatcity.com>

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
ineyman_at_perceptron.com

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:oramagic_at_hotmail.com] 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:oramagic_at_hotmail.com]
        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

--

Please see the official ORACLE-L FAQ: http://www.orafaq.net
--

Author: Igor Neyman
INET: ineyman_at_perceptron.com

Fat City Network Services    -- 858-538-5051 http://www.fatcity.com
San Diego, California        -- Mailing list and web hosting services
---------------------------------------------------------------------

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 Fri Mar 28 2003 - 11:23:39 CST