Re: SQL Files

From: Michael Serbanescu <mserban_at_postoffice.worldnet.att.net>
Date: 1997/09/23
Message-ID: <34287E1A.28B@postoffice.worldnet.att.net>#1/1

This reply is directed at the original poster, Zack Agatstein (I could not retrieve his original posting):

How do you run your SQL scripts: start (or @)<file_name>.txt or just <file_name> ? If the latter is the case, I suspect that your files have the .txt extension (being created with Notepad) and SQL*Plus is looking for files named <file_name>.sql, i.e. files with the .sql extension.

Another possibility: you are not providing the full path name for your scripts, and the directory where they are located is not listed in the SQLPATH variable.

Hope this helps.

Michael Serbanescu

---

Luis Ripoll wrote:
>
> El día Tue, 09 Sep 1997 11:42:43 -0700, Zachary Agatstein
> <Zachary.Agatstein_at_atsc.allied.com> nos cuenta lo siguiente:
>
> >
> >Hi!
> >I am trying to run SQL scripts that are ASCII text files (created under
> >Notepad) on the SQL*Plus 3.3.3.0.2. The system refuses to execute them.
> >What should I do? Is there a configuration option that I need to set?
> >My environment is:
> >Oracle Workgroup Server 7.3.2.2.1, Windows NT Server 4.0.
> >
> >Thanks
> >
> >Zack Agatstein
>
> Chek the length of your files names, it should be less than 8
> characters.
> --
> Para evitar la utilizacion abusiva de mi e-mail,
> he puesto una direccion no valida en mi 'From'.
> La correcta viene de sustituir 'no.vale.nada' por
> 'nauta.es'
> --
Received on Tue Sep 23 1997 - 00:00:00 CDT