Getting the name of currently executing sql script in sql*plus
From: Srinivas Chintamani <srinivas.chintamani_at_gmail.com>
Date: Fri, 4 Dec 2009 22:39:50 -0500
Message-ID: <98c5e2a20912041939s42a34d90nba255da3fb32eafb_at_mail.gmail.com>
Hi Listers,
Is there any way to get the name of the current script being executed by sql*plus?
Date: Fri, 4 Dec 2009 22:39:50 -0500
Message-ID: <98c5e2a20912041939s42a34d90nba255da3fb32eafb_at_mail.gmail.com>
Hi Listers,
Is there any way to get the name of the current script being executed by sql*plus?
For example..
I have the following levels of scripts ...
- Driver_Script.sql calls 2.....one.sql and 3.....two.sql 4.....three.sql which calls 5............four.sql and 6............five.sql.
What I want to be able to do is within each one of those scripts, "Get" the name of the script being executed. Is it possible to do this?
--
Regards,
Srinivas Chintamani
--
http://www.freelists.org/webpage/oracle-l
Received on Fri Dec 04 2009 - 21:39:50 CST