Re: dbms_job not running at sqlplus shell

From: ddf <oratune_at_msn.com>
Date: Wed, 2 Apr 2014 10:34:33 -0700 (PDT)
Message-ID: <fbe58282-a3aa-4047-b0d6-ce73596294e7_at_googlegroups.com>

On Tuesday, April 1, 2014 7:01:05 PM UTC-6, Chek Ban Tan wrote:
> 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...

I can't, actually. My system doesn't behave that way.

David Fitzjarrell Received on Wed Apr 02 2014 - 19:34:33 CEST