Our goal is to create an light weight packaged application and provide to any customers who wants to install and use the tool.
Can an application with database be built on Apex and created as packaged installable, instead of hosting in any Application , middle and database server. A kind of quick, cost effective and light weight installation? If yes,
We want to deploy an apex environment. I see that there are 3 methods for apex installation:
Scenario 1: Downloading from OTN and Configuring the Oracle Application Express Listener
Scenario 2: Downloading from OTN and Configuring the Embedded PL/SQL Gateway
Scenario 3: Downloading from OTN and Configuring Oracle HTTP Server
I think the applications that we will create in apex will have 50-100 users. We don't use RAC.
I installed and configures APEX in standalone mode about 2 weeks ago and played with it for short time. Now after 2 weeks I came back to start where I left off but APex_admin page would not come up.
I did following tasks as were found on Installed Apex on Oracle 11g. But cannot access admin screen
SQL> SELECT STATUS FROM DBA_REGISTRY
2 WHERE COMP_ID = 'APEX';
STATUS
-----------
VALID
SQL> conn sys as sysdba
Enter password:
[code]...
warning me that XDB requires username password to be sent through insecure manner (Basic authetication without a secure connection
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
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 RelatedI am trying to use the Apex listener 2.0 (instead of HTTP server). I installed and went thru the configuration of the listener, but I must be missing something. When I do the java -jar apex.war to start it up in standalone mode, I get the configuration properties etc., but when I open up my browser and try to bring up APEX with http://localhost:8080/apex/ I get a 500 - Internal Server error with the info below.
***********ERROR*********** init: # headers=43 declare nm owa.vc_arr := ?; vl owa.vc_arr := ?; begin owa.init_cgi_env( ?, nm, vl ); htp.init; htp.HTBUF_LEN := 63; ? := sys_context('USERENV','SID'); end; SID:880 CALL: begin apex; commit; end; BINDS PAGE CALL: declare nlns number := 999999; l_clob CLOB; lines htp.htbuf_arr; l_buff varchar2(32767); l_clob_init boolean:= false; l_file varchar2(5); l_doc_info varchar2(1000); begin OWA.GET_PAGE(lines, nlns); if (nlns > 1) then for i in 1..nlns loop if ( length(lines(i)) > 0 ) then if ( ( lengthb(l_buff) + lengthb(lines(i))) > 32767) then if (NOT l_clob_init) then dbms_lob.createtemporary(l_clob, TRUE); dbms_lob.open(l_clob, dbms_lob.lob_readwrite); l_clob_init:=true; end if; dbms_lob.writeappend(l_clob,length(l_buff),l_buff); l_buff := lines(i); else l_buff := l_buff || lines(i); end if; end if; end loop; end if; if (l_clob_init) then
[code]....
I'm trying to setup a dev machine to run APEX with RESTful services ahead of using Oracle's Cloud Database. Using Personal Edition, APEX 4.2.1 and the 2.0 Listener is up and running in standalone more. The problem is when hitting 'Test' on a selected REST Resource Handler, it comes up with an APEX 404 not found error, such as on the example HR REST handlers and a new test one setup.
I've followed all of the APEX and Listener instructions, run apex_rest_config.sql, ensured the various users are unlocked and tried both http and https (even though I've added the no SSL flag in the Listener config per standalone instructions.
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?
We have integrated Oracle Access Manager 11gR1 with Oracle Apex 4.1. The OAM-Apex integration is working fine. Now we want an additional header variable to be passed from OAM to the Apex application. This new header variable will be user's sAMAccountName in Active Directory. OAM is integrated with AD and the AD users are successfully able to access the Apex applications.
The three header variables which are configure in OAM right now are:
Header variable name Value
1. OAM_REMOTE_USER $user.userid
2. OAM_REMOTE_USER_EMAIL $user.attr.mail
3. OAM_REMOTE_USER_GROUPS $user.groups
We need an additional header variable as mentioned below:
Header variable name: OAM_SAMACCOUNTNAME
Value: $user.attr.samaccountname
The new header variable was added in the OHS server's dads.conf file like shown below:
=========== dads.conf =============
...
PlsqlCGIEnvironmentList HTTP_OAM_REMOTE_USER
PlsqlCGIEnvironmentList HTTP_OAM_REMOTE_USER_GROUPS
PlsqlCGIEnvironmentList HTTP_OAM_REMOTE_USER_EMAIL
PlsqlCGIEnvironmentList HTTP_OAM_SAMACCOUNTNAME
But we are not able to read the value of this attribute in the Apex application.On the Apex application, we have a text box which shows the value of this header variable. This textbox is attached with the following stored procedure call to fetch the header variable:
===================
begin
:P1_HEADER_VALUE := owa_util.get_cgi_env( 'HTTP_OAM_SAMACCOUNTNAME' );
end;
The textbox shows the correct value if HTTP_OAM_REMOTE_USER is passed to the get_cgi_env method but does not shows anything when HTTP_OAM_SAMACCOUNTNAME is passed to the same method. if I am missing some configuration to pass the HTTP_OAM_SAMACCOUNTNAME haeder variable from OAM to Apex.
How do I center a button within a region? I tried 'align="center"' but this seemed to be ignored. The button is at the left of the screen. Also, what are the 'display points' (Page Template Region Position 1-8) used for, and why is there a specification for column position of 1-9? Could these be attributes that will allow my button to be centered on the window instead of on the left?
View 3 Replies View RelatedI have a translated application in Apex, my Apex version is 4.2.1.00.08. The application is in production version, many people are using it on daily basis. The application's primary language is English, and it has translations for 5 languages. Everything is working fine now; even if there are minor changes in the application, we are able to seed it, download the XLIFF files and than publish the modifications into all translations. Simple so far. My problem is that I wanted to 'clone' the application including its translations to a new one since I plan to rebuild some parts of it. I want to keep the current version untouched, not to bother users. The new application should be in the same workspace, with a new ID. I have tried a couple of approaches: Copy the primary application enabling the option 'copy translation' - this creates a new app, and also seems to create new translated applications, which are empty (not seeded, not published). Export the primary application and than import it with a manually defined new application ID. Than do the same with the translated applications and set the proper IDs in the translation mapping part of Shared components > Translation. When I try to run the primary application, it is working, but for translated versions... Only an error saying that the application page does not exist. The purpose is to clone the whole thing by keeping the connection between the primary and the translated applications, so that if I change something in the primary application, it can be seeded into the translated ones later. In the same time I want to keep translations as well, since there are thousands of strings...
View 2 Replies View RelatedHaving an issue with logging into URL.... Just went through the install for APEX 4.2 for
Oracle 11.2.0.1 on Linux 2.6.32-358.el6.x86_64 #1 SMP Fri Feb 22 00:31:26 UTC 2013 x86_64 x86_64 x86_64 GNU/Linux.
Installed Apex with Embedded PL/SQL Gateway.Explicitly followed all the online instructions step-by-step, installation was success and config for EPG had no issues. Changed the ADMIN pw as instructed. Checked that EPG is running on port 8080. Ran this script to grant connect:
DECLARE ACL_PATH VARCHAR2(4000);BEGIN -- Look for the ACL currently assigned to '*' and give APEX_040200 -- the "connect" privilege if APEX_040200 does not have the privilege yet. SELECT ACL INTO ACL_PATH FROM DBA_NETWORK_ACLS WHERE HOST = '*' AND LOWER_PORT IS NULL AND UPPER_PORT IS NULL;[code]....
that lets power users to connect to everywhere',
'APEX_040200', TRUE, 'connect'); DBMS_NETWORK_ACL_ADMIN.ASSIGN_ACL('power_users.xml','*');END;/COMMIT;
When I go to log in it says "Invalid Login Credentials". I tried changing the admin pw several times but keep getting the same message.
I am wanting to open up an Item's Help popup feature using a different button.
I understand I need to call:
javascript:popupFieldHelp($('1234567','&SESSION.');
Where 1234567 is the items id.
So my question is how do I get the items ID?
I thought it was something similar:
$('#P1_ITEM_TEST').attr('id')
But this returns P1_ITEM_TEST, I want the ID or Sequence of the item.
We'll soon start an upgrade of our Forms / Reports 6i Application to 11g. I was wondering, maybe, it would be nice to add some value for the upgrade process as a whole, using some of Apex new features like web mobile interface or maybe an integration between Forms an Apex, for example to provide users with the powerful features of Interactive Reports, just to name one.
I have found this interesting link: URL.... (not a 100% clear for me, but at least it is a start).Obviously, to make it attractive, one would expect automatic login between the two Apps. As far as i know, this could be done like this:
1) Using SSO. With that a Portal / Forms / Reports/ Discoverer/ version would be mandatory (too expensive for some clients).
2) Oracle Access Manager? Not sure, can Oracle Forms connect to Access Manager? or LDAP? How about the licensing costs?. Not a clue.
3) Make all Apex pages public? Not feasible.
4) Now this one: in our forms application, every user authenticates within the application and we internally map that application user to an actual database user. At all times we hold metadata info about the current user (app, and DB), as well as application context. So this is my question:
It is possible to create an Apex app, with database authentication method, and somehow pass the metadata from forms, and have a kind of custom login procedure that does all the application to DB user conversion process and application context setting?
I want to print a report using the apex, but it looks like you need to configure BI, Is there an easy way to print it online and not print the page, which is page report.
View 3 Replies View RelatedI'd like to upload a video file (250MB) into our Apex app and have users click a link (Display Only item perhaps) and have the video launch either in Apex, or Windows Media Player. I've tried loading it into the Shared Components - Images, but it failed b/c the file was too large. I was considering loading it into a database table, but was hoping there might be an easier way. Right now we just have a link to the video on YouTube, but want something more professional.
View 2 Replies View RelatedI have a requirement to view the PDF content in the apex page region, I am using Apex 3.2 and Oracle 10 Enterprise edition. I Uploaded the PDF file in the shared component under static file. Now i need to view the content of the PDF file. method to view the PDF content.
I saw the link in denes blog here he shows how the PDF is getting displayed. but there is no steps of methods mentioned
[URL]...
I have a requirement to connect to APEX application from outside (a java program). The basic requirement is to post some data to APEX DB by a scheduled task.
View 3 Replies View RelatedI'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 RelatedI would like to run this procedure using a URL ... I have apex installed. What URL would I use. This procedure is compiled in the database. I have been trying to look thru the APEX installation guide for an example but I must be missing it somewhere.
CREATE OR REPLACE PROCEDURE ORASYSAD.HELLOWORLD is htp.print ('<hl>Hello World</hl>'); end;
I've created a system for managing football within APEX and it is at a stage now whereby the user can view any number of the tables through Reports and insert data into these tables through Tabular Forms. Its using triggers and sequences to allow for new primary keys to be generated each time within these Tabular Forms so I'm at a stage now where I'm really quite pleased with it..
The last thing I'm needing to do now is have it update certain fields when certain records are entered.
Clubs
clubId
clubname
gamesplayed
clubPoints
clubtotalgoals
Results
club1 (clubId foreign key from clubs table)
club2 (clubId foreign key from clubs table)
club1goals (the amount of goals, type Number)
club2goals (the amount of goals, type Number)
club1points (points earned, Type Number)
club2points (points earned, Type Number)
When filling out a result, the user will enter the following (as an example):
club1 - 1 (club with ID, 1)
club2 - 12 (club with ID, 12)
club1goals - 2 (the first club scored 2 goals)
club2goals - 0 (the second club scored 0 goals)
club1points - 3 (the first club picked up 3 points)
club2points - 0 (the second club picked up 0 points)
The result is then entered into the results table and what I am hoping to achieve at this stage is the following:
1) in the clubs table, the gamesplayed is incremented by 1 for both clubs as a result of playing this fixture
2) club1 has however many goals club1 scored added to its current clubtotalgoals field (in this case, it is of course 2)
3) club1 has however many points club1 earned to its current clubPoints field. (In this case it would be 3)
We are trying to integrate OBIEE 10g/11g and APEX 4.2. We would like to open report and a form in OBIEE so that users can update/writeback the data from OBIEE. Is there a way we can do this ?
View 0 Replies View RelatedI have one question I made a report and form in wizard with 1 table (Ex : EMP) and want to make a INSERT/UPDATE/DELETE process based on PL/SQL API. I think, mixing APEX_APPLICATION and APEX_ITEM pl/sql api can solve this question but not sure.... I have known the tabular form processing with PL/SQL via Oracle APEX book, but cannot find any samples on simple form processing.
View 5 Replies View RelatedI am using APEX 4.1.Using the documentation [URL]... I'm trying to implement my own custom error message.My problem: The placeholders in the text message are not replaced and I don't know what I'm doing wrong.
Example:
APEX_ERROR.ADD_ERROR (
p_error_code => 'This is a text message with one placeholder: %0',
p0 => my_variable,
p_display_location => apex_error.c_inline_with_field_and_notif,
p_page_item_name => 'P13_MY_PAGE_ITEM'
);The result is an error message as follows:
This is a text message with one placeholder: %0 (Go to error)
Note, I'm using APEX 4.1.1
The scenario is that I have tabular form that was manually created from a collection; the collection name is "COMPANY"
Within this tabular form, I have number of selection lists (apex_item.select_list) and for each, I fire off a JavaScript based on the "onchange" event (e.g.,'onchange="updateCollection(' || seq_id || ', 10, this.value)"'); updateCollection is a custom function I created. Right now, all it does is alert me with the specifics of the of the selection list. As a further example, if I select "Google" from the selection list, sequence id would be "1", attribute number would be "10" and attribute value would be "Google"
Within this JavaScript, I would like to update the value of this associated element in the "COMPANY" collection. Ideally, I would like to directly call this:
APEX_COLLECTION.UPDATE_MEMBER_ATTRIBUTE(p_collection_name => "COMPANY", p_seq => 1, p_attr_number => 10, p_attr_value => 'Google') but I could not figure out how to do this.
I need to converte apex app in welsh language and welsh is supported by apex.What other alternative we take apart from Apex default language translation.
View 0 Replies View RelatedIn Oracle Apex 5 SOD it says it will have the following feature:
"New Multi-Row Edit Region Type – Define a new region type with a modern UI for updating multiple rows of data and allow multiple regions on one page"
[URL].......
If so, how likely it will allow dynamic query (PL/SQL) in addition to simple query? Also, how likely it will include advanced features like frozen columns with group headers, subgrid, etc.? It will be nice if the grid will adjust itself based on the width of the screen.
I am trying to find a way to set the selected columns, like what the action menu -> select columns does. I am planning to build a AJAX Tree with check boxes, but I don't know where to pass that data to to update the selected columns. I'm sure their is a magic apex function that is passing the values of the current shuffle box, but as that is dynamically created, I have not be able to find that process / function.
Reason for this: Too many columns on the IR report. Want them divided by categories in a tree view. And no, I cant break the report up into multiple reports. Currently this report has 548 columns.
In my application I have a pop up lovs in which iam displaying text (description) and returning code to database. it is working fine but can I could not remove the underlines from the lov window as I know it is a select html links but tried in html form element attributes
style=color:black;text-decoration:none
still the under line is there. is this possible to remove underline in Apex Pop Up lovs.
I have over 27 views in apex and made a column name change in the views and after I compile about 4 or 5 of them, the apex engine crashes. I was compiling the data views first, before moving on to report views. When I upload the views and ran them in the as a script, it said all of the views were created.When I went into object browser most of the views compiled. I recompiled the ones that were marked red. I compiled them in the code window, incase it threw an error, I can fix it there.
I had problems with views, before causing core dumps when I compiled them, but figured I had to compile the views in a certain order.