Results 1 to 3 of 3
  1. #1
    Join Date
    Aug 2002
    Location
    France
    Posts
    3

    Unanswered: Problem to call a SQL Script ... (Error : SP2-0310)

    Hello,

    I would like to know how can I do to call SQL Script which is in a sub folder ?

    I've got a SQL script which call another script, "myScript", in the sub folder, "myFolder".


    The calling script contents : @@ .\myFolder\myScript.sql


    When a execute the script on SQL*Plus, I've got :


    SP2-0310: unable to open file ".\myFolder\myScript.sql"


    But when I call a file which is in the same folder, it's works ...

    How can I do ?

  2. #2
    Join Date
    Jun 2002
    Location
    Indianapolis
    Posts
    21
    Say you have a script called myscript.sql
    In that script, you want to call a file called myotherscript.sql located in a subfolder called misc.

    myscript.sql
    -------------
    select 'boo' from dual;
    @@misc/myotherscript.sql

  3. #3
    Join Date
    Aug 2002
    Location
    France
    Posts
    3
    Thanks but I tried and it does work ...

Posting Permissions

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