read SQL.....
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 7 of 7

Thread: read SQL.....

  1. #1
    Join Date
    Aug 2003
    Location
    Virginia
    Posts
    392

    read SQL.....

    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
    Rick

    Sigh.....those were the days my friend, I thought they'd never end.
    I too remember when this place was coo.


  2. #2
    Join Date
    Jan 2002
    Location
    Up s**t creek
    Posts
    1,525
    SQL is just text.

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

    HTH
    Jim
    Oracle Certified Professional
    "Build your reputation by helping other people build theirs."

    "Sarcasm may be the lowest form of wit but its still funny"

    Click HERE to vist my website!

  3. #3
    Join Date
    Nov 2002
    Location
    Geneva Switzerland
    Posts
    3,142
    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

  4. #4
    Join Date
    Nov 2002
    Location
    Geneva Switzerland
    Posts
    3,142
    Jim - SNAP!

  5. #5
    Join Date
    Jan 2002
    Location
    Up s**t creek
    Posts
    1,525
    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
    Jim
    Oracle Certified Professional
    "Build your reputation by helping other people build theirs."

    "Sarcasm may be the lowest form of wit but its still funny"

    Click HERE to vist my website!

  6. #6
    Join Date
    Aug 2003
    Location
    Virginia
    Posts
    392

    Thumbs up Read SQL

    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
    Rick

    Sigh.....those were the days my friend, I thought they'd never end.
    I too remember when this place was coo.


  7. #7
    Join Date
    Nov 2002
    Location
    Geneva Switzerland
    Posts
    3,142
    so I'll save a script as an all file type
    That's the trick.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  


Click Here to Expand Forum to Full Width