read SQL.....

[Alchemy]

Good day all. Here is my situation:
I have installed Oracle 9.0.0.1 on Windows 98.
Installation was "typical" with the pre-configured database.

After installation I proceeded to run some custom scripts.

I create the scripts using notepad, then saving as: name.sql
I run the scripts manually from the command/DOS prompt like this:
sql>@path\script.sql. After initiating the script I recieved a message saying that the
file could not be opened.

I know why the file could not be opened, the file was seen as
just text(scriptname.text when it was saved as:scriptname.sql). My question is, where
is that which reads and interprets a file as sql?, it has been my experience, everytime, to
have that which reads and interprets a file as sql when I run scripts. Can anyone
shed some light as to where I might find this program/application so that I may run
some sql scripts.

Thank you.
Rick

[jovery]

SQL is just text.

Make sure that when you saved the file is wasn't saved as scriptname.txt.sql

HTH

[DaPi]

I create the scripts using notepad, then saving as: name.sql

Watch out with notepad - if the "Save as type" is "Text Documents (*.txt)" then you will have saved a file: name.sql.txt

[DaPi]

Jim - SNAP!

[jovery]

Not quite DaPi as I've noticed that I got my filename the wrong way round (.txt.sql), you where correct (.sql.txt)

Damn those crazy typing fingers of mine

[Alchemy]

DaPi and Jim.
Thanks, I'll double check that this evening when I can get back at my system. I have only two "save as" type option, they are .txt and all files, so I'll save a script as an all file type and give it a go.

Thanks again.

Oh DaPi, at the last second I decided to go with Oracle 9i Personal on Windows 98SE. I have my suspicions that I will likely upgrade 98SE to 2000 Pro then downlopad Oracle 9i Enterprise.

Rick

[DaPi]

so I'll save a script as an all file type

That's the trick.