Sitemap

Amicuk Programming Answers

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

2015-10-11   Views: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, 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
I have a requirement for to create one payment terms for 9 days. i have completed configuration, but when we have done testing it was pulling 10th days insteady of 9th day like one day after. can anybody help us whre we have done wrong?Hi Reddy... Re [More]
Hi, When we are creating new transport routes with domain controller ABC. It is giving the above dump. Dont know what to do. FYI we deleted previous TMS config and created new one. Thanks, RohanCheck the values which you are passing to the BDC.. the [More]
Is it possible to suppress those lines in the legend of a pie chart where the underlying data is zero, and consequently where no slice is displayed? Regards Greg DavisWrite a condition for that field in format editor: Suppress if nullRead other 2 ans [More]
I've changed my Passport email from POP3 to IMAP (using a 1&1 uk account). If an email is delivered while I'm using Outlook on my laptop, it correctly appears once in my Outlook inbox but about 30 unread copies of it arrive in my hub on the passport. [More]
Hi, I recently bought X2-01 I want to know that is there any way to lock or hide folders in X2-01? Need Help Regards Shan ALi KhanHi shankhan The Nokia X2-01 runs under S40 6th Edition, which does not allow the user to hide items on the gallery or fi [More]
I am having a strange problem. I have an exchange 2010 server on windows 2008 r2 that has been working perfectly for more than a year. Now suddenly I can't open the EMC or even the EMS. I get this error, "The attempt to connect to the server using ke [More]
Hi, I'm using a tabbed panel to separate the main subtopics for the main page of a website. The only problem I'm having is that the panel reverts to the default tab when you leave the page and then return. The only exceptions seem to have to do with [More]
I have an Mac running iOS v10.9.4 and I currently have Photoshop Elements 10 installed. I'm trying to download the  Photoshop Elements 12 trial version. The Install Adobe Download Assistant has been copied to my Downloads folder. When I try to open t [More]
Hey! I'm a pro photographer and amateur - entry level video editor. I do lots of photoshop and lightroom works and lately I've been doing lots of Final Cut Prox stuff as well. Basically, i handle lots of media, which is probably the worst scenario fo [More]
Hi I created website from template and i adpated the most things in it. Im still a noob, but working on it. The most problems i could solve but if you look at the images below; you can see in IMAGE 1 that there is no problem at the bottom of page, th [More]