Results 1 to 2 of 2
  1. #1
    Join Date
    Jan 2004
    Posts
    16

    Unhappy Unanswered: simple batch file gone wrong!

    I want to write a batch file that runs a stored procedure that I have within oracle. How, oracle says "unable to open file "c:\test3.sql"
    Here is the code

    1st file: test.bat

    sqlplus username/passwd@dbname @C:\test2.sql

    2nd file: test2.sql

    execute procedure;


    For some reason, the batch file is unable to open the test2.sql file. The location of this sql file is correct. Any other possiblities?
    Jason B. Simms

  2. #2
    Join Date
    Jan 2004
    Posts
    16

    Re: simple batch file gone wrong!

    Originally posted by bosshog33
    I want to write a batch file that runs a stored procedure that I have within oracle. How, oracle says "unable to open file "c:\test3.sql"
    Here is the code

    1st file: test.bat

    sqlplus username/passwd@dbname @C:\test2.sql

    2nd file: test2.sql

    execute procedure;


    For some reason, the batch file is unable to open the test2.sql file. The location of this sql file is correct. Any other possiblities?

    Nevermind. I found out that it was just something stupid. The name of the test2.sql was really named test2.sql.txt.
    Jason B. Simms

Posting Permissions

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