Home > Default > Virtual Directory Change from Oracle HTTP Server to Embedded PL/SQL Gateway

Virtual Directory Change from Oracle HTTP Server to Embedded PL/SQL Gateway

October 11Hits:4
Advertisement
We finally upgraded from htmldb 1.6 to ApEx 3.1.2 late last year. This was in conjunction with setting up a new server and installing Oracle 11g DB, while our production DB is still 10g. During this install, I opted for the Embedded PL/SQL Gateway, whereas our htmldb is running with the Oracle HTTP Server.
During the conversion of one of our applications I learned that Virtual Directory references to #IMAGE_PREFIX# are no longer valid for custom CSS so I had to change an entry in the page templates that I'm using to use #WORKSPACE_IMAGES#. Now I am importing another application from our htmldb 1.6 environment to our ApEx 3.1.2 environment, and I have a new problem that I think is related.
In this application we have been uploading report files for outside users to be able to download at their convenience. I think the upload is working OK, but when I try to download the report file I get the following:
Not found
The requested URL /apex/IMR.ofile was not found on this server.
The download is accomplished with a link on an SQL Report region. The Column Link info is:
Link Text = <img src="#IMAGE_PREFIX#edit_big.gif" border="0" alt="Icon 1">
Target = URL
URL = #OWNER#.ofile?p_file=#VIEW_REPORT#&v_auth=&APP_USER.
When I change the Link Text to <img src="#WORKSPACE_IMAGES#edit_big.gif" border="0" alt="Icon 1"> I lose the Edit Icon image. However, what I'm really concerned about is the URL not found error
Now, maybe I'm barking up the wrong tree, so if the problem isn't related to virtual directories, which tree should I be barking up?
Any suggestion?
Thanks,
Gregory

Answers

Is the IMR.ofile a custom package for downloading files? If so, you might need to add it to the wwv_flow_epg_include_mod_local function.
I am not certain how this function also plays into the embedded pl/sql gateway, but do know it would affect this running through Oracle HTTP server when configured with the before proc.
With the embedded gateway it may very well be that you need to add this package into the ACL for outside availability.

Read other 3 answers

Tags:

Related Articles

  • Virtual Directory Change from Oracle HTTP Server to Embedded PL/SQL GatewayOctober 11

    We finally upgraded from htmldb 1.6 to ApEx 3.1.2 late last year. This was in conjunction with setting up a new server and installing Oracle 11g DB, while our production DB is still 10g. During this install, I opted for the Embedded PL/SQL Gateway, w

  • SSL on ORACLE XE APEX 4 EMBEDDED PL/SQL GATEWAYOctober 11

    Hello Can somebody explain how to configure SSL for oracle xe apex 4.0 on windows server step by step from begining to end? I've tried different examples, but I failed to make. Thank you!Hi, I found this post. It might help you Oracle 11g, APEX 3.0.1

  • Can you run Embedded PL/SQL Gateway and Oracle HTTP Server at the same timeOctober 11

    Hi, I know this will sound a bit odd but their is a business case for asking this. Can you run APEX via the Embedded PL/SQL Gateway and the Oracle HTTP Server at the same time? Would their be any security/stability/etc issues I'd need to worry about?

  • Logging into APEX through Oracle XML DB HTTP Server and Embedded PL/SQLOctober 11

    Hi, I have just finished installing Apex 3.0 on RHEL 4. I am not using HTTP Server, but Embedded PL/SQL. When I go to the page administrator page http://host:8080/pls/apex/apex_admin a prompt pops up and when I give the username as "admin" and t

  • Can I change from Embedded PL/SQL Gateway to Oracle HTTP Server/Apache?October 11

    Hi everyone Can I change a running installation of Oracle 10.2.0 Application Express 3.2.1.00.10 to move away from the Embedded PL/SQL Gateway on to the Oracle HTTP Apache server? I'd like the change to be as transparent as possible to avoid an outag

  • Oracle Virtual Directory vs. Oracle External Authentication Plug-inNovember 30

    I am working in Windows 2003 Server platform and I have Oracle Portal 10g R2 with Oracle Single Sign On 10g R2 setup. I also have Microsoft Active Directory setup. I want to use Microsoft Active Directory users from Oracle Portal and as per my unders

  • Virtual context creation on Oracle Application ServerNovember 30

    How do we set up a context in Oracle Application Server? and how to map servlets and jsp to this context?Hi, I am not sure about your exact needs, but it is the responsibility of the developer to provide a Deployment Descriptor ( an XML File that con

  • Add virtual directory to orion-web.xml file of embedded OC4J instanceNovember 30

    I'd like to add a virtual directory to the orion-web.xml file of the embedded OC4J application which comes with JDeveloper (version 10.1.3.3.0.4157). Every time I run my application however, a new orion-web.xml file is created which overwrites the or

  • How to access Oracle Mobile Server logs using PL/SQL?November 30

    I am starting to use Oracle solutions so I am a complete rookie. I'm doing a project which requires to present the logs of mobile devices using the Oracle Mobile Server (integrated in Oracle Database Lite). Does the mobile server have services I coul

  • Workflow server end embedded PL/SQL and XDBOctober 11

    Hi, I read in the Installation Guide that we must use Apache. We have Oracle 11.1.0.7 and embedded PL/SQL (from APEX) and don't use Apache. Is it possible to do so and install Workflow server without a HTTP-Server? Thank you for your help SiegwinThe

Copyright (C) 2019 wisumpire.com, All Rights Reserved. webmaster#wisumpire.com 14 q. 0.600 s.