SQL*Plus scripting

From: Gints Plivna <Gints.Plivna_at_softex.lv>
Date: Wed, 8 Dec 2004 18:01:53 +0200
Message-ID: <69721CE0FE0D59478756C2926DF54E500F823C@saturn.softex.local>

So I'm stuck with the subj.
Oracle 9.2.0.5 on Linux, client (my box) MS Windoze XP

I have following directory structure and sql scripts just for example:

qaqa1.sql          level 1
2\qaqa2.sql        level 2
2\anotherqaqa2.sql level 2
2\3\qaqa3.sql      level 3

So I'd like to call from the root script qaqa1.sql one level below i.e. = qaqa2.sql, and from qaqa2.sql one more below i.e. qaqa3.sql. But somehow = I cannot force to do that, level 2 script cannot see level 3 script. I'v = read docs, used @, @@ all possible combinations I could think of but no = success.
Although I can force if I write in qaqa2.sql following @1\2\qaqa3.sql like it would be called directly from level 1 script. But = this solution isn't an option because I need run root script that = contains many sublevels as well as sublevels separately.

Any solution?

TIA Output from SQL PLUS

19:36:15 gints_at_CMISMGR2> @qaqa
19:36:15 gints_at_CMISMGR2> @@2/qaqa2.sql
19:36:15 gints_at_CMISMGR2> PROMPT IN qaqa2.sql

IN qaqa2.sql
19:36:15 gints_at_CMISMGR2> @3/qaqa3.sql
SP2-0310: unable to open file "3/qaqa3.sql" 19:36:15 gints_at_CMISMGR2> @@3/qaqa3.sql
SP2-0310: unable to open file "3/qaqa3.sql" 19:36:15 gints_at_CMISMGR2> @2/3/qaqa3.sql
19:36:15 gints_at_CMISMGR2> PROMPT IN qaqa3 IN qaqa3
19:36:15 gints_at_CMISMGR2> @@2/3/qaqa3.sql 19:36:15 gints_at_CMISMGR2> PROMPT IN qaqa3 IN qaqa3
19:36:15 gints_at_CMISMGR2> @anotherqaqa2.sql SP2-0310: unable to open file "anotherqaqa2.sql" 19:36:15 gints_at_CMISMGR2> @@anotherqaqa2.sql 19:36:15 gints_at_CMISMGR2> PROMPT anotherqaqa2 anotherqaqa2

Gints Plivna
A/S =84SOFTEX LATVIA=94
Kr.Barona iela 13/15, R=EEga, LV-1011
tel: +371 7365111; fakss: +371 7365109
e-mail: g.plivna_at_softex.lv
WWW: http://www.softex.lv

--
http://www.freelists.org/webpage/oracle-l

Received on Wed Dec 08 2004 - 10:06:43 CST