OraFAQ Forum: Client Tools

Home » Other » Client Tools » @@ confusion (SQL*Plus: Release 10.2.0.3.0, winXP)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

@@ confusion [message #500912]

Thu, 24 March 2011 08:28

xerces8
Messages: 3
Registered: March 2011

Junior Member

Hi!

I have a script test\a.sql with the line:

@@ extra/foo.sql

The files are:
test\a.sql
test\extra\foo.sql

If I am in the map "test", I can run the script by:
sqlplus _login_data_ @ a.sql

and it works. It also works if I use single @ in the script.

But if I am a directory higher, I get this:

sqlplus _login_data_ @ test\a.sql

SP2-0310: unable to open file "extra/foo.sql"

Isn't the difference between @ and @@ that the later should work in cases like this? That it looks for the referenced script relative to the position of the first script?

Report message to a moderator

Re: @@ confusion [message #500914 is a reply to message #500912]

Thu, 24 March 2011 08:34

LKBrwn_DBA
Messages: 487
Registered: July 2003
Location: WPB, FL

Senior Member

According to the fine SQL*Plus® User's Guide and Reference, this is how it works:
Quote:

@@ file_name[.ext] [arg...]

Runs a script. This command is almost identical to the @ (at sign) command. When running nested scripts it looks for nested scripts in the same path or url as the calling script. The @@ command functions similarly to @ and START.

[Updated on: Thu, 24 March 2011 08:45] by Moderator

Report message to a moderator

Re: @@ confusion [message #500928 is a reply to message #500914]

Thu, 24 March 2011 09:48

xerces8
Messages: 3
Registered: March 2011

Junior Member

Yes, by reading this and the example on that page, I understand that it should work as I expect it in the first post, but it does not.
It looks in the current directory instead, it seems.

In other words, how can I can I call other scripts in my script, without hardcoding the absolute path to them? Put them all in same directory?

Report message to a moderator