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 :)
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
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
hereigoagain, you're welcome . Glad I could help :-)
ASKER
That was really helpful :)