Sitemap

Amicuk Programming Answers

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

2015-10-11   Views:9

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, w

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

The replay answer
Advertisement
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.

Go to See the other 3 answers

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

Category:DefaultRelease time:2015-10-11Views:130

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[More]

SSL on ORACLE XE APEX 4 EMBEDDED PL/SQL GATEWAY

Category:DefaultRelease time:2015-10-11Views:130

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[More]

Can you run Embedded PL/SQL Gateway and Oracle HTTP Server at the same time

Category:DefaultRelease time:2015-10-11Views:130

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?[More]

Logging into APEX through Oracle XML DB HTTP Server and Embedded PL/SQL

Category:DefaultRelease time:2015-10-11Views:130

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[More]

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

Category:DefaultRelease time:2015-10-11Views:130

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[More]

Oracle Virtual Directory vs. Oracle External Authentication Plug-in

Category:DefaultRelease time:-0001-11-30Views:130

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[More]

Virtual context creation on Oracle Application Server

Category:DefaultRelease time:-0001-11-30Views:130

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[More]

Add virtual directory to orion-web.xml file of embedded OC4J instance

Category:DefaultRelease time:-0001-11-30Views:130

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[More]

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

Category:DefaultRelease time:-0001-11-30Views:130

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[More]

Workflow server end embedded PL/SQL and XDB

Category:DefaultRelease time:2015-10-11Views:130

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[More]

How to Configure DAD entry in Oracle 11g by embeded pl/sql gateway

Category:DefaultRelease time:-0001-11-30Views:130

Hello frnds...i want to configure dad entry. i am using dad(default) by pl/sql gateway.. Or suggest to use by Http server.. VivekI have some procedures using owa , generating html in oracle9i and now I will upgrade DB to oracle11g R2, What do I have[More]

Hot
Hi All, I have a requirement where the client wants to dsiplay the image of a particular characteristics in the Bex report. For example, they have a charaacteristic Material, and they have the images of all the materials. The requirement is to displa [More]
Hi, is it possible to add a column in Gantt chart in cProjects project display? There is a BADI DPR_GANTT method GET_GANTT_PARAMETERS, but it is possible only to delete the columns, while I need to put a new column there. Is that possible? Thank you. [More]
I just started using Acrobat 8 Professional. And I have six Social Security forms I need to scan into Acrobat and make them into fillable forms right away. I have read the documenation but I still don't understand how to do what I need. 1. After I fi [More]
I need to update a legacy library so that it can draw to an NSWindow with agl and Carbon. I actually have no problem drawing, the problem is that I am drawing over the window decorations and don't know how not to. Has anyone run into this problem? Th [More]
Hello friends. I'm faced with a situation in which I need to create and parse many relatively small xml documents. Most of the XML I will be exchanging is very simple, such as: <? xml version="1.0"?> <transactionId>12345</transact [More]
Good Morning all, Well, I am hoping that someone out there will be able to help me solve this problem. Ok, here's the deal. I have a 3g iphone and have set up 4 email accounts under settings, no problems. Yesterday I tapped the mail app. and saw the [More]
I just installed BitDefender Anti-virus and did a system scan.  The results turned out that I have a number of threats found on my backup volume (external drive for time machine to back up on).  The threats are all  "exploit.pdf-js.gen".  Howeve [More]
yo... my MacBook was purchased 15 months ago and guess I am having the same problem with many guys in this section... battery shows 0% at all time with power plugged in with static green light.. supposed to be orange light when battery is not full ri [More]
Ok I was just using photoshop, not doing anything differently and I went to use the eraser and set the opacity down a bit and put it over a picture but noticed doesnt erase and make the edges of the picture fade but makes a big line which has just lo [More]
Hello there, I am testing AnyConnect Secure Mobility Client, Network Access Module as supplicant with PEAP authentication for wired network users. With default configuration it is working well.  With default configuration it is Trusting any Root CA c [More]