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
I do not see this: Please hover the mouse (cursor) over the snapshot, and you'll find there are 4 icons on the top. The icons are there for : open in newtab, edit, refresh and remove.Hi, Sorry for the misleading, however, the icons are not shown in t [More]
Hello all, I am new to SD (and new to ABAP for that matter) so have a lot to learn. I am to write a report program to produce a list of documents containing information about commercial partners and their full address. That is to say, town, country, [More]
I'm wondering whether or not to get yet another warranty exchange for my ipad 3 over this horrible screeching sound associated with the home button.  I was told at the Apple Store by the technician that he had never heard of this problem before and t [More]
Hello all IE experts, It seems that IE has "Handles" leak when it calls Java Applet. Every call to a Java method from JavaScript, IE allocate a handle and does not free it. THIS DOES NOT HAPPEN when I use mozilla or Netscape. Versions: * Windows [More]
Hi essbase experts, I am trying to build dimension using rules file. My outline is - Product A B C D SALE Price STOCK Quantity YEAR 2007 jan2007 feb2007 mar2007 I created a rules file . in the field "product" I unchecked the option" ignore [More]
I need to resize a bi-tonal 600 DPI PDF image only file by 80% of original size. When I process this file it turns the pages into grey scale pages. How do I turn this off and just keep the image as bi-tonal.Sorry about that the subversion is 9.4.0 an [More]
Customize AJAX Blueprint Autocomplete component ? Can you control the size of the result box generated ? Can you control what happens when you click on a result row in the result box ? I would like to specify the size of the result box, and possible [More]
Hi All,   When I hit Fiori Launchpad I got the error as show in Image.   Please find the attachment for error messge.   Kindly advice. Thanks, Babu Tags edited by: Michael ApplebyHi Masa, Please check UI components which exist in my System. And error [More]
Hi i have an application which has grown very large and im hoping theres some kind of tool out there for looking at the source code and determining which classes are used. Does any1 know about anything which does this? Or can any1 suggest a good way [More]
I am trying to write a quick shell script that will monitor the number of connections in a connection pool along with the amount of available memory to a WL server. The weblogic.Admin commands are very limited and I was hoping someone could tell me t [More]