Link to home
Start Free TrialLog in
Avatar of hereigoagain
hereigoagain

asked on

How can I rename the page that is created by a SP in Oracle ?

Hello,

I have a Stored procedure that exports data from the DB to a browser with the HTP package.
(The procedure export is in xls format (OWA_UTIL.MIME_HEADER( 'application/vnd.ms-excel' );) )
The SP is named ExportToIE so when I save it as a file, the file is named ExportToIE.
Can I change the name of the page/file/the title  when exporting it to the html page , f.e. sth like ExportToIE_YYYYMMDD because when I try to use the export again without closing the previous window it tells me that 'a document with the name ExportToIE is already open ... ' and I have to close it first..

I tried changing the html title with HTP.TITLE(V_TITLE) - but that did not help.

I'll be glad to see any suggestions :)
ASKER CERTIFIED SOLUTION
Avatar of Andytw
Andytw
Flag of United Kingdom of Great Britain and Northern Ireland image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of hereigoagain
hereigoagain

ASKER

Thanks a lot Andytw !
That was really helpful :)

hereigoagain, you're welcome .  Glad I could help :-)