Skip to main content

Home/ BI-TAGS/ Group items tagged apex

Rss Feed Group items tagged

cezarovidiu

Oracle Apex Thoughts.: How to send an email from apex 4.2 and 11g XE - 0 views

  •  
    "How to send an email from apex 4.2 and 11g XE To accomplish sending an email from your Oracle Apex application using oracle database 11g r2, you must use the new DBMS_NETWORK_ACL_ADMIN package to grant connect privileges to any host for the APEX_040200 database user. To start things off, begin by installing a free mail server emulator in your development environment. I used Melon 1.0 that can be downloaded from http://www.softpedia.com/get/Internet/Servers/E-mail-Servers/Viktor-Melon.shtml. After unpacking the archive just place the folder anywhere in your file system. The sample mails sent will be stored in the .Melon sub directory. Secondly connect to the database as sys user and run the following script: DECLARE   ACL_PATH  VARCHAR2(4000); BEGIN   -- Look for the ACL currently assigned to 'localhost' 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 = 'localhost' AND LOWER_PORT IS NULL AND UPPER_PORT IS NULL;      IF DBMS_NETWORK_ACL_ADMIN.CHECK_PRIVILEGE(ACL_PATH, 'APEX_040200',      'connect') IS NULL THEN       DBMS_NETWORK_ACL_ADMIN.ADD_PRIVILEGE(ACL_PATH,      'APEX_040200', TRUE, 'connect');   END IF;   EXCEPTION   -- When no ACL has been assigned to 'localhost'.   WHEN NO_DATA_FOUND THEN   DBMS_NETWORK_ACL_ADMIN.CREATE_ACL('local-access-users.xml',     'ACL that lets users to connect to localhost',     'APEX_040200', TRUE, 'connect');   dbms_network_acl_admin.assign_acl('local-access-users.xml','localhost'); end; The third step is to set the smtp settings in Apex. 1.    Log in to Oracle Application Express Administration Services. If your setup uses the embedded PL/SQL gateway, go to: http://hostname:port/apex/apex_admin 2.    Click Manage Instance. 3.    Under Instance Settings, click Instance Settings. 4.    Under Email, enter the following: 1.    SMTP Host Address - Defines the server
cezarovidiu

Create an Application to Upload Files Using Oracle APEX, In Less Than 10 Minu... - 0 views

  • Create an Application to Upload Files Using Oracle APEX, In Less Than 10 Minutes (Video)
  • APEX includes declarative BLOB support that enables you to declaratively upload files in forms, and download or display files in reports (ittichai wrote about it here).
cezarovidiu

Installing and configuring the APEX Listener 2.0.1 on WebLogic 12c | SnapDBA - 1 views

  •  
    "Installing and configuring the APEX Listener 2.0.1 on WebLogic 12c"
cezarovidiu

PDF print reports for APEX - 0 views

  • J4L APEX FO Designer
  • Compatible with Apache FOP and Apex Listener.
cezarovidiu

Saving Current Values with Cascading LOVs - 0 views

  •  
    "Saving Current Values with Cascading LOVs A friend, Monty Latiolais, recently asked an interesting question regarding cascading LOVs: Say you've got two LOVs...STATES and CITIES. They both default to 'ALL' and 'ALL'. Since CITIES is dependent on STATES, as soon as STATES is changed, CITIES is blanked out. What should happen is that CITIES gets re-evaluated as in the following example... let's say STATES is ALL and CITIES is "Houston". If one then changes STATES to "Texas", CITIES should remain "Houston" as that is a valid value for CITIES. So basically, is it possible to maintain the selected value of an item if that same value exists in the list of values after refreshing? That's a great question! Thanks to new events in the APEX framework and Dynamic Actions the solution is far easier than it would have been in the past! Click here to see the demo but continue reading to learn how it all works… There are a three main events you need to be concerned with when it comes to cascading selects: change apexbeforerefresh apexafterrefresh The change event is a standard part of JavaScript and the DOM. This event fires when the user manually changes the value of the select list but can also be triggered programmatically via JavaScript. The apexbeforerefresh and apexafterrefresh events are custom events in the APEX framework. They fire just before and just after AJAX requests refresh something on the page. The events work with many items and regions that utilize this technology. In this example we have two select lists: parent and child. If you change the value of the child select list then the change event will fire and that's it. But if you change the value of the parent select list a lot more happens to the child select. Here are some of the highlights: The current LOV values are cleared out The apexbeforerefresh event is triggered An AJAX request brings back new values. This only happens if optimize refresh is set to false optimize refresh is set to true and
cezarovidiu

Dancing and Wrestling with Oracle APEX: Apex and FusionCharts (or There be dragons at t... - 0 views

  • All of which led me to FusionCharts, which is a brilliant set of flash charts and widgets.
  • All I had to do was figure out how to integrate it into my app. First I had to write a function to extract the data I needed from my database and output it as correctly-formatted XML. That bit was easy so I won't bore you with it.
  • Next I uploaded the Flash (SWF) file for my chart into my workspace. (Tell me something: when you upload an image to your application using Apex's image uploader you refer to it by pointing at # APP_IMAGES#, so how do you think you'd refer to a file you've uploaded using Apex's file uploader? #APP_FILES#? Wrong! Illogically, all files uploaded into your application should be pointed at using the #APP_IMAGES# substitution string.)Finally, I created a dynamic PL/SQL content region outputting the necessary wrapper tags for my Flash movie (which I copied from the FusionCharts examples), pointing it to my uploaded swf file and feeding it the XML from my database function (which I call in "before regions" page process).
cezarovidiu

Category: APEX Tricks - 0 views

  • APEX 4.2 resizable interactive report column heading menu
cezarovidiu

oracle - Update Apex Tabular form with PLSQL - Stack Overflow - 0 views

  • Update Apex Tabular form with PLSQL
  • for i in 1..apex_application.g_f02.count loop update dept set dname = apex_application.g_f03(i) where deptno = apex_application.g_f02(i); end loop;
cezarovidiu

Using BIRT with Apex for PDF reports | emoracle - 0 views

  • Using BIRT with Apex for PDF reports
  • http://localhost:8080/birt-viewer/frameset?__report=test.rptdesign&sample=my+parameter.
  • http://localhost:8080/birt-viewer/frameset?__report=departments.rptdesign&p_deptno=10&__format=pdf
cezarovidiu

Understanding the Oracle REST Data Services Configuration Folder | cdivilly - 0 views

  • java -jar ords.war configdir /tmp/wls/conf
  • Configure ORDS by doing: 1java -jar apex.war
  •  
    "java -jar apex.war"
1 - 20 of 92 Next › Last »
Showing 20 items per page