find currenlty open file's filename

[bdjb]

Hello,
Is it possible to write code that will return the currently open file's filename? And if so, does anyone have an example?

Thank you in advance

 

[SantaMufasa]

Is it possible to write code that will return the currently open file's filename?

Which file? Database data file? On-line redo log file? Control file? Some non-Oracle flat file?

If you are asking about one of the first three, then the answer is, "If the database instance is up and running, then each file is open, by definition."

Please clarify what you mean, and please tell us a bit more about your need for such information, so that we can better tailor a response to meet your need.



Mufasa
(aka Dave of Sandy, Utah, USA)
[I provide low-cost, remote Database Administration services: www.dasages.com]

 

[bdjb]

Sorry, I guess that was rather vague. I'm writing a report in Oracle Reports, and am trying to find what the filename of the report is. In Crystal you can get the file name using the FileName function, but I can't find anything like that in Reports. (the reason for it is: higher ups want the filename to print in the header area of the report, and I was hoping to get it dynamically)

Thanks

 

[SantaMufasa]

Sorry...Oracle has nothing that dynamically tells you what file names to which you are writing. Oracle figures, "If anyone/anything should know what files he's writing to, it should be he."

Mufasa
(aka Dave of Sandy, Utah, USA)
[I provide low-cost, remote Database Administration services: www.dasages.com]

 

[bdjb]

OK, thank you. We'll just have to put the file name in a text field.

 

[SantaMufasa]

Exactly !

Mufasa
(aka Dave of Sandy, Utah, USA)
[I provide low-cost, remote Database Administration services: www.dasages.com]