sql*plus for command window

[tcogill]

I've found a difference in behavior between a Command Window and SQL*Plus:

Assume these files exists...
c:\database\main.sql
c:\database\sql\test.sql

test.sql contains a simple select
> select 'test' from dual;

main.sql contains a call to test.sql
> @@.\sql\test.sql

Any thoughts as to why this works in PL/SQL Developer Command Window but not in SQL*Plus.

I'm spinning my wheels. Haven't gone to Oracle with this yet, wanted to see if anyone here experienced it.

Thanks.
- Tim

 

[Marco van der Linden]

@tcogill

Have you set the working directory of SQL*Plus to 'C:\database' ? Because the default SQL*Plus working directory is \bin. So your main.sql would effectively be calling \bin\sql\test.sql