Re: dbms_job not running at sqlplus shell
From: joel garry <joel-garry_at_home.com>
Date: Mon, 31 Mar 2014 09:16:59 -0700 (PDT)
Message-ID: <36524a18-9e82-46fa-8b03-4067b09ef64c_at_googlegroups.com>
Date: Mon, 31 Mar 2014 09:16:59 -0700 (PDT)
Message-ID: <36524a18-9e82-46fa-8b03-4067b09ef64c_at_googlegroups.com>
On Monday, March 31, 2014 3:42:58 AM UTC-7, Chek Ban Tan wrote:
>
>
>
> Hi,
>
> the sql run at command prompt is not stable , sometimes it can be executed but most of the time it hang there.
>
> its not privilege issue.
>
>
>
> The job does not have error.
Do things work differently if you put an exit command at the end of the sql file? Is it "stable" in toad but not sqlplus?
jg
-- _at_home.com is bogus. http://www.computerworlduk.com/news/careers/3509255/uk-oracle-user-group-launches-cv-service-for-graduates/Received on Mon Mar 31 2014 - 18:16:59 CEST