Re: Exiting a .sql

Does "sometimes" mean?
 you run the script Monday and it waits at the prompt, but running the same script on Tuesday exits?
or
 you run the script on machine A and it waits at the prompt, but running the same script on machine B exits?

If it's the first case, I'm at a loss without more detail. If it's the second case, then it seems you should already have a clue. (examine the OS, account, database differences for the cause.)

I still don't know what you mean by environment. is it:  different machines
 different user logins
 different oracle databases
 ?

Some questions are too vague to answer.

"Matthieu DEGLIN" <mdeglin_at_remove-me.partner.auchan.com> wrote in message news:<9vd5ak$6o7$1_at_reader1.imaginet.fr>...
> The surprising thing is that sometimes it exits without 'Exit' !
>
>
> Alistair a écrit dans le message <9vd4vu$lsl$1_at_thorium.cix.co.uk>...
> >Dont you just add
> >
> >exit
> >
> >to your sql script?
> >
> >Alistair
> >
> >
> >"Matthieu DEGLIN" <mdeglin_at_remove-me.partner.auchan.com> wrote in message
> >news:9vcklu$17g$1_at_reader1.imaginet.fr...
> >> Hello,
> >> Under Unix I launch the following command:
> >>
> >> sqlplus usr/pwd @my_sql.sql
> >>
> >> my_sql looks like:
> >>
> >> spool my_fic
> >> select xxx from xxx;
> >> spool off;
> >>
> >> There isn't any 'Exit' in my_sql.
> >>
> >> On a certain environement it exists on an other it shows the SQL prompt
> >> (SQL>).
> >> Is it linked to a version of sqlplus ?
> >> Any other idea ?
> >>
> >> Thanx for help
> >> Matt.
> >>
> >>
> >
> >
Received on Fri Dec 14 2001 - 12:05:23 CST