XE :: Map Default Apex URL
Mar 27, 2013I'm using apex 4.2 with Weblogic server. Right now our url to the application is
[URL].......
How can we make it much more simpler like
[URL].......
ADVERTISEMENT
SQL & PL/SQL :: Default Values / Distinguishing Between Passed And Default Nulls
Nov 16, 2010I was looking for a way to see if a default value for a procedure was passed NULL or it got NULL by default. [URL]
View 11 Replies View RelatedApplication Express Listener :: APEX Listener With APEX 3.0 On 11gR2?
Jun 29, 2012We 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?
PDF Attachment From Apex Application?
Aug 8, 2011I am using Apex 4.0.
We have a requirement to send the html contents saved in the CLOB column of a table as PDF attachment in the email from apex application. Currently we are sending the .htm file as the attachment from the apex application.
include the html contents as a PDF document with some small examples.
Currently I am using APEX_MAIL.ADD_ATTACHMENT to include the attachment and APEX_MAIL.SEND to send the mail. Currently we are sending the attachment in the .htm format.
The html data is present in the column of a table, which we are sending in the attachment as a htm file. Any example to send the PDF attachment using APEX_MAIL.ADD_ATTACHMENT.
Apex Tabular Field
May 27, 2010I need to get that a tabular field works as FORMS LOV when I choose the value and storage the description in a tabular field and the code or ID in another tabular field... Then I need to show to end user a POPUP LIST like FORMS...
Assuming that the end user can insert new records into tabular forms.
HTML Region - Apex JavaScript?
Sep 12, 2010I have a html region with the following
<html>
<head>
<title>Report</title>
</head>
<script language="JavaScript1.2">
function items()
[code]...
I have a text box item "BINDTEST" that has html element set to:onchange="items();"
I have a button with a url redirect of:
javascriptopon[URL}...
When I click on the button, popup window opens with test url but bindtest1 variable is not appended. What is proper form for trying to get value of bind variable in the url.
XML DB :: APEX Soap Web Service Response Into DB
Oct 29, 2013How do i get a response from a soap webservice and insert it into a DB
View 0 Replies View RelatedApplication Express :: Cannot Log Into Apex Admin
Sep 16, 2013Having 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.
Turning Table Model Into DDL To Import Into APEX?
May 1, 2013We use apex and my professor wants us to import a table model into apex. everytime i try and import my table it says "your export file is not supported". i asked my professor what to do and he said "You should gen a ddl file from designer. Then use that to upload into apex and then run.
View 1 Replies View RelatedAPEX ADMIN Access From Remote Machine
Oct 18, 2010I have installed oracle 11g and configured Apex application on it. I am able to open the Admin window from my machine . URL.... and everything works fine. But when I try to open the link from other machine I get "Server not found" error.
I read the posts it says to enable Http for other servers . I dont find the way to do it .
Application Express :: Get ID (Number) Of Apex Item
Jan 15, 2013I 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.
Application Express :: How To Call Apex From Forms Without SSO
Feb 6, 2013We'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?
Application Express :: How To Print File In Apex
May 26, 2013I 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 RelatedApplication Express :: Launch Video From Apex App
Oct 5, 2012I'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 RelatedApplication Express :: Display PDF In Apex Region?
Jul 11, 2012I 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]...
Application Express :: Connecting To APEX From Outside World?
Oct 4, 2013I 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 RelatedCloud Service :: DB Hosting Specifically APEX?
Oct 3, 2012 if APEX hosting allows access to the file system so that access to javascript, css and images files can be passed to a webserver?
What webserver comes with hosting - is this the Apache 1.3 that comes with 11g?
Application Express :: PDF Printing Via APEX Listener
Oct 21, 2013I'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 RelatedApplication Express :: URL For APEX To Run A Stored Procedure
Jun 26, 2013I 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;
Application Express :: Updating Records Within APEX?
Mar 11, 2013I'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)
Application Express :: Integrate OBIEE 10g / 11g and APEX 4.2
May 29, 2013We 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 RelatedApplication Express :: How To Manipulate DML In Apex Form (not Tabular)
Aug 12, 2013I 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 RelatedApplication Express :: Usage Of Placeholders In Apex-error?
Feb 21, 2013I 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)
Application Express :: Updating APEX Collection Via JavaScript?
Aug 1, 2012Note, 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.
Application Express :: Convert APEX App In Welsh Language?
May 9, 2013I 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 RelatedApplication Express :: Oracle Apex 5 SOD - Multiple Regions
May 24, 2013In 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.
Application Express :: Set IR Columns Outside Of Action Menu (APEX 4.0.1)
Jan 30, 2013I 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.
Application Express :: Possible To Remove Underline In Apex Pop Up Lovs
Sep 25, 2012In 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.
Application Express :: Views In 4.1.1 Is Crashing Apex Engine
Dec 11, 2012I 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.
Application Express :: How Does Apex Determine Which Files To Serve
Apr 11, 2013I'm using apex 4.2.1.00.08 and I cannot figure out how apex manages the static files and cannot find anything in the docs (other that some high level UI description). The application is serving some file and I cannot find which one it is in any easy way.
I have a workspace where there are several files that have the same name, and I cannot understand how apex figures out which one to serve, and also don't understand what is value of associating a file with an application.
There are files associated with application 0, which don't appear to show up in the "shared components", but can be seen as
SELECT *
FROM wwv_flow_files
WHERE flow_id = 0;
and can apparently only be deleted using "SQL Commands" inside apex. the URL called is something like
wwv_flow_file_mgr.get_file?p_security_group_id=13498126233076320&p_fname=myfile.css
so apparently the only parameters that matter are the workspace and the file name. The associated application is irrelevant. apparently files linked to flow_id 0 have precedence over all the other files..