Application Express Listener :: How To Upgrade From 1.1.4 To 2

Feb 18, 2013

how to upgrade Oracle apex listener from 1.1.4 to 2.We are using Oracle apex listener with Glassfish 3.1.2.

View 0 Replies


ADVERTISEMENT

Application Express Listener :: Using PL/SQL Procedure / Function In Resource Template (listener 1.1.3)

Feb 15, 2013

I'd like to call an existing function/procedure from a resource template. For example, I have a procedure called 'rest' with an out parameter of 'p_out' - how do I use this within a resource template?

At the moment I have defined the template as type 'PL/SQL Block' and with the 'GET' defined as:

begin
myschema.rest(:p_out);
end;

APEX_PUBLIC_USER has been granted 'all' on the procedure. The p_out is populated with a piece of text.

When I call this resource, I get a '500 Internal Error' returned. I've tried adding p_out as an X-APEX-FORWARD parameter, but nothing seems to work.

Query-based templates seem to work OK.

Using Listener 1.1.3 with Tomcat6.

View 0 Replies View Related

Application Express Listener :: APEX Listener With APEX 3.0 On 11gR2?

Jun 29, 2012

We have many many APEX applications in APEX 3.0 running on a 10.2.0.4 database that needs desperately to be upgraded. As a test, I've set up a clean 11gR2 database and copied the production APEX database into it via datapump. I set up APEX Listener, as I don't have any OAS sitting around and the EPG doesn't seem to be supported for APEX 3.0... the Listener doesn't say one way or the other.

When trying to log in, I get the login page, but it tries to reference files such as apex_get_3_1.js while I only have files such as htmldb_get.js in my images directory in production. I noticed it is looking for what appears to be 3.1 files instead of 3.0 files... which concerns me.

The APEX listener appears to be more than just a Java PL/SQL gateway.

Is there a minimum version of APEX the APEX Listener supports?

View 2 Replies View Related

Application Express :: Errors In Lib After 4.2 Upgrade

Jan 15, 2013

We have upgraded our environment to Apex 4.2.1. We have an older application that makes use of Apex Lib. We cannot remove Apex Lib from the application without a lot of work.

Apex Lib is now throwing an error:

in package apexlib_error procedure addApexValidationErrors WWV_Flow.g_validation_ids_in_error does not exist.

View 2 Replies View Related

Application Express :: Oracle 11g XE - 4.2.3 Upgrade

Nov 13, 2013

I have downloaded Oracle 11g XE and installed it on my laptop, Win 7 Enterprise Everything works great, DB admin page comes up, APEX comes up (4.0.2.x). I download the Apex_4.2.3_en.zip. I extract the zip file and then follow the instructions in, Downloading from Oracle Technology Network  essentially the apexins.sql, apxldimg.sql with the admin password changes and anonymous user unlock. 
This is the install command, @apexins SYSAUX SYSAUX TEMP /i/ 

I get the  Error processing request  ORA-010403: no data found.

View 3 Replies View Related

Application Express :: 4.2.2 Upgrade Not Working?

Aug 7, 2013

We have upgraded our apex installation from APEX 4.0.2 to 4.2.2 and APEX listener to 2.0.2

Below is our configuration

Host 1 : Oracle databaseOracle database - 10.2.0.5APEX - 1.1.3
Host 2 : Apex listener on Weblogic serverWeblogic server - 10.3.5 APEX listener - 2.0.2

Post the upgrade , applications that were existing before the upgrade are not working properly.

Errors faced:1.When we edit any page in application - we get no data found error2.

When we run any application - We get no data found error We are able to create new applications without any issues.Luckily , we had the export backup of one application taken before upgrade. We imported that back( only one application ) and that application is working fine. We imported the application in apex.oracle.com as well and get the same error[URL]... occurs during page 'Edit' as well.

View 11 Replies View Related

Application Express :: Connect To Listener From LAN

Dec 11, 2012

I've just instaledl APEX on Oracle 11g, with APEX listener 1.1, working fine at localhost. But I can't reach it from others computers on LAN. I searched several threads about this and thought I should run

EXEC DBMS_XDB.SETLISTENERLOCALACCESS(FALSE);

But when I execute that, I got the message 'ORA-30952: illegal configuration of HTTP/HTTPS in xdbconfig.xml'.

View 6 Replies View Related

Application Express Listener :: Generate PDF With 2.0?

Apr 2, 2013

we would like to generate pdf out of apex. as long as we have text (IRR) WITHOUT special characters (öäü), everything is working fine.when we have this characters in a text-columng (IRR), then we get a .pdf with the following content:

javax.xml.transform.TransformerException: com.sun.org.apache.xml.internal.utils.WrappedRuntimeException: An invalid XML character (Unicode: 0x3) was found in the element content of the document.

- we defined in ADMIN in 'report printing' / 'instance-settings': oracle-apex-listener

- we are working with apex-listener 2.0 (integrated in weblogic-server)

- we work with APEX 4.2.1.00.08

View 2 Replies View Related

Application Express Listener :: How To Use Java With 4.1

Jun 5, 2012

i m using apex 4.1 and the database is oracle *11g* i want to know how to use the java (servlet,jsp,all technologies of java in apex ) and what i have to do to use the java in apex

View 3 Replies View Related

Application Express Listener :: 2.0 And RewriteRule

Sep 20, 2012

I am currently hosting a number of APEX applications, using OHS as the webserver and I looking into using the APEX Listener instead. However I have a lot of rewwriterules in my OHS configuration. Is this something that can be configured in the APEX Listener?

<VirtualHost *:80>
ServerAdmin webmaster@dummy-host.example.com
DocumentRoot "${ORACLE_INSTANCE}/config/${COMPONENT_TYPE}/${COMPONENT_NAME}/htdocs"
ServerName application-a.example.com
RewriteEngine On
RewriteRule ^/$ URL....
</VirtualHost>--Andy

View 3 Replies View Related

Application Express :: Email Not Working After 4.1 Upgrade

Jun 11, 2012

O/S: Windows 2003
DB: 11gR1

Email no longer working for users after upgrading from 4.0 to 4.1. New 'principal' APEX_040100 added to same ACL as previous version's principal APEX_040000. In fact, both still exist in ACL.

Error code in APEX Admin Mail Queue: ORA-24247: network access denied by access control list (ACL)

What could be causing the email facility within APEX to no longer work?

View 1 Replies View Related

Application Express :: Upgrade Failed In Database From 10g To 11g

Jul 30, 2012

When we upgraded the database from 10g to 11g, Apex upgrade failed. Due to the failure, I removed the old schema and did a fresh install of Apex 4.1. It is working but we lost the applications from previous Apex.

What is the best strategy when you need both database and Apex upgrades? We are a Linux workshop, setting up Apex in Oracle Fusion Middleware 11g environment.

View 0 Replies View Related

Application Express :: PDF Printing Via APEX Listener

Oct 21, 2013

I'm attempting to configure printing via the APEX listener and I'm struggling to understand it.  I currently use Oracle HTTP server as the web server for APEX.  I have installed the APEX listener and configured it.  If I connect via the APEX listener, PDFs work correctly.  If I connect via the Oracle HTTP server, I get an error with PDFs.  Am I required to connect with the APEX listener for PDF printing?  I thought I could configure APEX listener for PDF printing on the backend and still connect via Oracle HTTP server. I'm use APEX 4.2.3, APEX Listener 2.0.5, and Oracle DB 11.1.0.7.

View 5 Replies View Related

Application Express :: Delete Message Not Displaying When Upgrade To 4.1

Jul 31, 2012

I am in the middle of upgrading my application to Apex 4.1 from 3.2.1. I have been using the default delete message and now it won't work.

<script langues="javascript" type ="text/javascript"
<!--
htmldb_delete_message='"DELETE_CONFRIM_MSG"';
//-->
</script>
button action

redirect to url ----> javascript:confirmDelete(htmldb_delete_message,'DELETE_RATING');

now all I receive is a message from the webpage, instead of the message.

View 4 Replies View Related

Application Express :: 4.2 Theme Upgrade - Best Way To Reorganize Pages

Nov 14, 2012

I have been given the task to modify our company's Apex from 4.1 to 4.2. The upgrade has been completed; in addition, the current UI, blue and tan has been updated to BlueJay. I have noticed the structure of the page gets shuffled as well as contents within modules. What would be the best way to "re-organize" my pages.

- Would it be easy for me modify the page, if so how do I do this. The settings look identical, so what would I change ?
- Do I recreate the entire page from scratch ?

View 15 Replies View Related

Application Express :: Oracle SSO Authorization Not Working After Upgrade To 4.2.1

Jan 3, 2013

I have enabled SSO for my application. It was working in 4.1 version. I have upgraded to 4.2 now and the same code doesn't work now.I have created an authentication scheme where i check if a particular person is an employee based on a flag. If he is, then I return 1 to the authorization scheme i have created. This always returns 0 even if the flag is set to 'Y'. I have tried hard coding the user_id as well. It doesn't work.

I tried printing the :APP_USER but it does not give any output.

View 1 Replies View Related

Application Express :: No Page Edit Functionality After Upgrade To 4.2.2?

Jul 12, 2013

Apex has been upgraded from 4.1 to 4.2.2. I don't know if the upgrade was done correct or not by the administrator, but I don't have the page edit link anymore,

and anytime I run a individual page from the Edit Application, I have to Log in. Did something went wrong during the upgrade or is this the behavior of Apex now, which I don't think so.

View 1 Replies View Related

Application Express Listener :: Page Is Blank And Freezed

Jan 15, 2013

Problem is that page is blank and freezed. After another enter in URL page is shown normally.What I find out is that "freeze" happened only in Apex design time ... never in runtime of any of mine app.

Mine conf:
Apex 4.2.1 on
Apex Listener standalone 2.0.0.354.17.06
Oracle 11.2.03 x64
Windows 2008 SE R2 x64

C:UsersDamirV>java -version
java version "1.6.0_34"
Java(TM) SE Runtime Environment (build 1.6.0_34-b04)
Java HotSpot(TM) 64-Bit Server VM (build 20.9-b04, mixed mode)error log:
D:UsersdamirvDesktopApexApex-Misc>set ORACLE_HOME=c:oracleproduct11.2.0dbhome_1
 [code].....

View 4 Replies View Related

Application Express Listener :: Restful Webservice 404 Not Found

Apr 18, 2013

i am running the following configuration:

Oracle Database 11.2.0.3
Application Express 4.2.1
apex_listener.2.0.1.64.14.25 on Glassfish 3.01

Everything works fine except the restful webservices. In SQL-WorkShop when i create a simple GET webservice and klick on "Test"" 404 not found" comes up in the browser.In the log i can see:

Request Path passes syntax validation
Mapping request to database pool: PoolMap [_poolName=apex, _regex=null, _workspaceIdentifier=null, _failed=false, _lastUpdate=-1, _template=null, _type=REGEX]
Applied database connection info
Attempting to process with PL/SQL Gateway
Not processed as PL/SQL Gateway request
Attempting to process as a RESTful Service
Determining if request can be dispatched as a Tenanted RESTful Service
Request path has one path segment, continuing processing
No Tenant Principal established yet, continuing processing
APEX_LISTENER pool exists, continuing processing
No matching tenant found for: ifc, cannot dispatch
No candidate found for: GET ifc/certification in context: URL....

View 3 Replies View Related

Application Express Listener :: Log Errors When Uploading File?

Sep 28, 2012

I get an ERR-7621 from Apex whenever I do anything in an application the tries to read a file. For example importing images, css files, themes, or applications. Even the data loader app will get the error if you choose to load a "csv" file. The following appears in my Apex Listener Log (version 2 early adopter). I am running 4.1.1 of Apex and also have another server running the same where the problem does not exist. Following is the log output whenever the load occurs:

Sep 28, 2012 11:21:18 AM com.sun.grizzly.http.servlet.ServletAdapter doService
SEVERE: service exception:
java.lang.NumberFormatException: For input string: ""
at java.lang.NumberFormatException.forInputString(NumberFormatException.java:48)

[Code].....

View 1 Replies View Related

Application Express Listener :: GlassFish Admin Page

Jul 30, 2013

My configuration is GlassFish 4 (the same thing with Glass Fish 3.2) + win7 + Apex Listener 2.2 (the same thing with  Apex Listener 2.1) + Apex 4.2.2 I get blank page when trying to connect to APEX. But after loggin into GlassFish admin page (exactly login with username+password; just open admin page is not enough) in another browser tab I get proper Apex page with all images.

View 1 Replies View Related

Application Express Listener :: EA2 Standalone CLOB Error

Jan 15, 2013

I use the "Media Resource" RESTful service type to generate custom JSON objects via CLOB-returning functions. This worked great in APEX Listener 1.1.3. However, on APEX Listener 2.0 I get status 500 on a RESTful service which works fine on 1.1.3 (which generates a clob > 4000 bytes), and the following in the server log:

SEVERE: ORA-22922: nonexistent LOB value

oracle.dbtools.common.UnrecoverableException: ORA-22922: nonexistent LOB valueThis seems to be the same issue as reported here:

APEX Listener EA2 Standalone CLOB error

As stated by thoechst in that thread:

>
It is as though the function is getting cast as a varchar2 somewhere. I verified that the function will correctly return a large result to other sources (dbms_output, for instance).
>

Versions:

APEX Listener 2.0
WebLogic 10.3.6 on Windows 2008 SE R2 x64
Oracle DB 11.2.0.3

View 1 Replies View Related

Application Express Listener :: String Index Out Of Range

Dec 19, 2012

I have, it would appear, successfully installed APEX 4.2 & APEX Listener 2.0 EA (in WebLogic). APEX works fine and it's reverse proxied using mod_weblogic through the OHS. I have configured APEX Printing to be via the APEX Listener.

However, creating a simple report, enabling printing, running the report (e.g. PDF or Word) produces the following few-byte content (only) inside the actual PDF file (obviously not in PDF format):

String index out of range: -1

Furthermore, it throws the exception below on the WebLogic console.

Any experience with the APEX Listener - and if so managed to rectify it?

SEVERE: String index out of range: -1
java.lang.StringIndexOutOfBoundsException: String index out of range: -1
at java.lang.String.substring(String.java:1931)
at oracle.dbtools.apex.hooks.postProcess.FOP2PDF.requestTOPDF(FOP2PDF.java:82)
at oracle.dbtools.apex.hooks.postProcess.FOP2PDF.postProcess(FOP2PDF.java:36)

[Code]...

View 2 Replies View Related

Application Express :: 4.2.2 Upgrade Now Giving Apex_mail ORA_2427 ACL Error

Sep 30, 2013

We just upgraded to APEX 4.2.2.00.11 and we are getting ORA-24247: network access denied by access control list (ACL) errors form apex_mail. This had been working correctly prior to the upgrade.

View 4 Replies View Related

Application Express :: 4.2 Upgrade - Unable To Test Report Queries?

Apr 5, 2013

After upgrading to Apex 4.2 I'm now unable to test Report Queries. Each time I click on the Test Report button via Shared Components|Report Queries I recieve the following error message:

ORA-20001: The printing engine could not be reached because either the URL specified is incorrect or a proxy URL needs to be specified.

I still have Apex version 4.1 installed on a different server and it appears to be working fine.

View 1 Replies View Related

Application Express :: Upgrade Within Oracle XE Database Installation On Windows 7

Aug 28, 2012

O/S: Windows 7 64-bit
DB: Oracle XE 11g2 32-bit
APEX: 4.0.2
=============

Trying to upgrade APEX within an Oracle XE database installation on Windows 7. The version of APEX that came with Oracle XE is 4.0.2. Trying to upgrade to 4.1.1 and, from the SQL*Plus command-line (ie. the 'Run SQL Command' tool which comes with Oracle XE), I try to run @apexins.sql.

It starts to run momentarily, then the MS-DOS windows just closes. Can not find any install log to determine the cause.

View 2 Replies View Related

Application Express Listener :: Standalone Vs Deploy To J2EE Container

Jan 16, 2013

I planing use latest APEX listener and Apache with mod_jk on new server.I wonder what are pros and cons use APEX listener standalone comparing when deployed to J2EE container e.g. Glassfish? URL.....

View 4 Replies View Related

Application Express Listener :: Configuration - How To Change From Port 80 To 8080

May 29, 2013

I installed apex and configure the apex listener at port 80 by mistake couldn't pay attention to use port 8080. The installation is complete but the apex is running at URL.... but the login window is invisible on the page. I can just see the name on the tab "Application Express Login" . When i click on the error message at the bottom of the browser, the message says "apex is undefied" line 35.

When I run the server, I get a message "No free port within range 80. How can I change from port 80 to 8080? how to either un-install the listener or change the port 80 to 8080

View 3 Replies View Related

Application Express Listener :: How To Upload File Using Restful Service

Feb 4, 2013

I want to upload file using restful service This is my code to send file to rest service

MultipartEntity reqEntity = new MultipartEntity(HttpMultipartMode.BROWSER_COMPATIBLE);
FileBody bin = new FileBody(f);
FormBodyPart bodypart = new FormBodyPart("file", bin);
reqEntity.addPart(bodypart);

[code]...

But how can i retrive at server side in restful service using plsql?

View 0 Replies View Related

Application Express Listener :: Calling Plsql Procedure From Web Browser?

May 9, 2013

I have problems with calling procedure directly from webbrowser. I have a procedure test in test_pkg package. I granted execute on it to anonymous , added it to wwv_flow_epg_include_mod_local function and still have error 404.searched this forum and found this: Does listener use wwv_flow_epg_include_mod_local

So I granted to apex_public_user and created synonym for him to my package. And it starts working. But then I wanted to add next proceudre to my package the same way, and change my test procedure and it stop working again. Now I have 404 error again.

View 3 Replies View Related







Copyrights 2005-15 www.BigResource.com, All rights reserved