Re: dbms_job not running at sqlplus shell

From: Chek Ban Tan <chekban_at_gmail.com>
Date: Tue, 1 Apr 2014 18:01:05 -0700 (PDT)
Message-ID: <93fa78c6-11a0-4bd6-b403-b840a734ad65_at_googlegroups.com>

On Tuesday, April 1, 2014 12:16:59 AM UTC+8, joel garry wrote:
> 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/

It is the same even though we put exit command at the end of the sql .there is no issue when running in Toad, problem only happens when running in sqlplus, you can simulate this at your end actually... Received on Wed Apr 02 2014 - 03:01:05 CEST