SQL*Plus scripting
- From: "Gints Plivna" <Gints.Plivna@xxxxxxxxx>
- To: <oracle-l@xxxxxxxxxxxxx>
- Date: Wed, 8 Dec 2004 18:01:53 +0200
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@CMISMGR2> @qaqa
19:36:15 gints@CMISMGR2> @@2/qaqa2.sql
19:36:15 gints@CMISMGR2> PROMPT IN qaqa2.sql
IN qaqa2.sql
19:36:15 gints@CMISMGR2> @3/qaqa3.sql
SP2-0310: unable to open file "3/qaqa3.sql"
19:36:15 gints@CMISMGR2> @@3/qaqa3.sql
SP2-0310: unable to open file "3/qaqa3.sql"
19:36:15 gints@CMISMGR2> @2/3/qaqa3.sql
19:36:15 gints@CMISMGR2> PROMPT IN qaqa3
IN qaqa3
19:36:15 gints@CMISMGR2> @@2/3/qaqa3.sql
19:36:15 gints@CMISMGR2> PROMPT IN qaqa3
IN qaqa3
19:36:15 gints@CMISMGR2> @anotherqaqa2.sql
SP2-0310: unable to open file "anotherqaqa2.sql"
19:36:15 gints@CMISMGR2> @@anotherqaqa2.sql
19:36:15 gints@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@xxxxxxxxx
WWW: http://www.softex.lv
--
//www.freelists.org/webpage/oracle-l
Other related posts:
