Results 1 to 7 of 7
  1. #1
    Join Date
    Sep 2009
    Posts
    4

    Unanswered: Problems with a sql script

    Hi everyone,

    I just switched back to Oracle XE from Oracle Standart edition and I have a sql

    script that I'd like to execute from sqlplus.So far what I did is I positioned

    myself in the folder that contains the script that I want to lanch :

    cd c:\<path_to_the_folder_that_contains_the_sql_scrip t_>

    Then bringed up sqlplus and called the .sql file ,

    SQL>start mysqlscript.sql

    I get :

    SP2-0310: impossible d'ouvrir le fichier "mysqlscript.sql"

    Basically its telling me that it's impossible to open the file "mysqlscript.sql"

    So I tried with the full path

    SQL> start "C:\Program Files\EasyPHP 3.0\www\CappsPhpPBanks\sql>mysqlscript.sql"

    And now I have an other error :

    SP2-0556: Nom de fichier incorrect.

    Saying that the file name is incorrect

    My configuration:

    Windows XP

    Oracle XE 10g


    Any help would be greatly appreciated.


    Ilyas


    Welcome to COUNTAPPS! : where applications count

  2. #2
    Join Date
    Aug 2003
    Location
    Where the Surf Meets the Turf @Del Mar, CA
    Posts
    7,776
    Provided Answers: 1
    >SQL> start "C:\Program Files\EasyPHP 3.0\www\CappsPhpPBanks\sql>mysqlscript.sql"

    Problem is most likely the ">" character near the right end of the string above; between "sql" & "mysqlscript.sql"
    You can lead some folks to knowledge, but you can not make them think.
    The average person thinks he's above average!
    For most folks, they don't know, what they don't know.
    Good judgement comes from experience. Experience comes from bad judgement.

  3. #3
    Join Date
    Sep 2009
    Posts
    4
    Quote Originally Posted by anacedent
    >SQL> start "C:\Program Files\EasyPHP 3.0\www\CappsPhpPBanks\sql>mysqlscript.sql"

    Problem is most likely the ">" character near the right end of the string above; between "sql" & "mysqlscript.sql"

    Thanks very much for your help but now I get the first error again :


    SQL> start "C:\Program Files\EasyPHP 3.0\www\CappsPhpPBanks\sql\mysqlscript.sql"
    SP2-0310: impossible d'ouvrir le fichier "C:\Program Files\EasyPHP 3.0\www\Capps
    PhpPBanks\sql\mysqlscript.sql"

    And I opened sqlplus from the folder where the script is;I have never done this with XE and I have to admit I didn't do this everyday with the standart
    edition but I do rember it used to work fine without even having to put the whole path.I know that this is a path problem , I just don' t know how to fix it!!

  4. #4
    Join Date
    Jan 2004
    Location
    Croatia, Europe
    Posts
    4,094
    Provided Answers: 4
    As of myself, when working with Oracle, I try to avoid such a long directory names and - especially regarding Forms - directory names that contain space (i.e. "my oracle"). I rather create "C:\my_oracle" and put everything in there (subdirectories are fine, of course, keeping in mind restrictions mentioned above).

    So, just for testing purposes, copy that SQL file into the root directory of the C drive and try again. Something like this:
    Code:
    C:\>sqlplus scott/tiger@ora10
    
    SQL*Plus: Release 10.2.0.1.0 - Production on Uto Ruj 8 07:21:29 2009
    
    Copyright (c) 1982, 2005, Oracle.  All rights reserved.
    
    
    Connected to:
    Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - Production
    With the Partitioning, OLAP and Data Mining options
    
    SQL> start mysqlscript.sql
    
      COUNT(*)
    ----------
            22
    
    SQL>

  5. #5
    Join Date
    Sep 2009
    Posts
    4
    Quote Originally Posted by Littlefoot
    As of myself, when working with Oracle, I try to avoid such a long directory names and - especially regarding Forms - directory names that contain space (i.e. "my oracle"). I rather create "C:\my_oracle" and put everything in there (subdirectories are fine, of course, keeping in mind restrictions mentioned above).

    So, just for testing purposes, copy that SQL file into the root directory of the C drive and try again. Something like this:
    Code:
    C:\>sqlplus scott/tiger@ora10
    
    SQL*Plus: Release 10.2.0.1.0 - Production on Uto Ruj 8 07:21:29 2009
    
    Copyright (c) 1982, 2005, Oracle.  All rights reserved.
    
    
    Connected to:
    Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - Production
    With the Partitioning, OLAP and Data Mining options
    
    SQL> start mysqlscript.sql
    
      COUNT(*)
    ----------
            22
    
    SQL>
    Thanks for the reply , that was actually the problem; I remeber this limitation now!!


    This is a good forum , I'll come check it out as often as I can!

    Thanks everone.

    Ilyas

    http://countapps.clanfree.net
    Last edited by mbenyaich; 09-08-09 at 11:56.

  6. #6
    Join Date
    Aug 2009
    Location
    Olympia, WA
    Posts
    337
    My guess is the space in the path was actually the problem. Gotta love Windows.

  7. #7
    Join Date
    Sep 2009
    Posts
    4
    Quote Originally Posted by artacus72
    My guess is the space in the path was actually the problem. Gotta love Windows.
    Yes indeed !!

Posting Permissions

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