tag:blogger.com,1999:blog-18331017811018224202024-03-18T23:31:12.541-04:00Another Oracle BlogInohttp://www.blogger.com/profile/05100729748140066283noreply@blogger.comBlogger21125tag:blogger.com,1999:blog-1833101781101822420.post-18642905130758490972022-03-31T22:09:00.006-04:002022-03-31T22:09:59.035-04:00Easy APEX email using JsPDF In my previous post, I explained how to easily create a PDF document of a part of a web page created with APEX.Now that we know how to create, download and possibly print the PDF, the question arises: can we email this PDF file?So, here is our APEX again, now with button Email:The JavaScript to create the PDF file is more or less the same. Instead of downloading the file, we now upload the Inohttp://www.blogger.com/profile/05100729748140066283noreply@blogger.com0tag:blogger.com,1999:blog-1833101781101822420.post-8551461699099989592022-02-14T22:03:00.002-04:002022-02-15T22:05:09.814-04:00Easy PDF reports in Oracle APEX A frequent question on APEX forums is: how do I create simple reports, like tickets, invoices etc.Of course you can use some real report generator, like Apex Office Print (AOP) or Jasper. But in some cases the solution may be really simple: an APEX region and jsPDF to create a PDF document of that region. This may work if you are sure that your report will be just one page, like most Inohttp://www.blogger.com/profile/05100729748140066283noreply@blogger.com0tag:blogger.com,1999:blog-1833101781101822420.post-66128604521395109652021-10-15T09:35:00.004-04:002022-02-11T14:06:02.028-04:00Dynamic Actions on cards in Oracle APEX cards regionOracle APEX card templates and card regions already have quite a few options you can set via the APEX Builder.In a card region, a card can have an action, but the options are limited to a link to another page or URL. What if you just want to click on a card and draw attention to the selected card and set some item value based on that selection? Something like this:This approach needs some Inohttp://www.blogger.com/profile/05100729748140066283noreply@blogger.com9tag:blogger.com,1999:blog-1833101781101822420.post-25047057659186291902016-10-14T10:18:00.002-04:002016-10-14T10:18:37.651-04:00Testing Apex 5 menus with Selenium IDERecently I started testing other web applications using Selenium IDE. Of course, the techniques can be used for Apex web applications too.
There are so many different aspects on web pages to take into account. What works in one application doesn't work in another. My first serious challenge in using Selenium IDE for testing Apex 5 applications was to get the drop down menu's to work. You don't Inohttp://www.blogger.com/profile/05100729748140066283noreply@blogger.com0tag:blogger.com,1999:blog-1833101781101822420.post-42336203255879868042015-08-23T16:30:00.001-04:002015-08-23T16:30:52.667-04:00Generate an Apex menu from DesignerIn my previous post I showed you how can re-use Designer domains to generate domain LOV's.
Another Designer to Apex feature is the Module Structure to Menu List conversion.
Apex 5 now uses Lists for the menu structure instead of the old Tabs in Apex 4. This makes it really easy to make a menu structure based on the Module Structure in Designer.
Start with a menu structure table in your Inohttp://www.blogger.com/profile/05100729748140066283noreply@blogger.com0tag:blogger.com,1999:blog-1833101781101822420.post-78900775259250134982015-06-03T10:11:00.000-04:002015-06-03T10:12:40.907-04:00Oracle Designer and Forms to Apex: List of ValuesIf you are converting your Oracle Designer and Forms to Application Express (Apex), there are some components you can easily re-use. One of them is domain List of Values.
Domains and domain values are typically stored in table CG_REF_CODES. From this table it is simple to generate Apex List of Values for each domain.
declare -- Modify v_flow_id to your application ID
v_flow_id&Inohttp://www.blogger.com/profile/05100729748140066283noreply@blogger.com0tag:blogger.com,1999:blog-1833101781101822420.post-51268085243054427892013-03-20T15:43:00.001-04:002013-09-12T12:09:09.411-04:00Apex tree and form one one pageI had an idea to combine a tree and a form in one page. Actually, just because I never used a tree before (yes, really), and also because I couldn't find an example on internet. The Oracle Sample Trees application shows how you can use a tree node with a link to another form page. That is a waste of a lot of space on the right side of the page. What I wanted is this:
Basically, you need to Inohttp://www.blogger.com/profile/05100729748140066283noreply@blogger.com0tag:blogger.com,1999:blog-1833101781101822420.post-8819555516824076512013-02-04T15:32:00.000-04:002013-02-18T16:43:49.864-04:00Apex and RESTful web servicesYou always read that it is so easy to consume RESTful or SOAP web services in Apex. Well, yes, when you know how it works. It took me some time to figure it out, googling for bits of information on every step. If you are struggling too, this may help you to get started.
The start lies in the database, and has nothing to do with Apex. You must make sure first that the web service you need can be Inohttp://www.blogger.com/profile/05100729748140066283noreply@blogger.com0tag:blogger.com,1999:blog-1833101781101822420.post-53693500872731666702011-02-09T12:34:00.003-04:002011-04-20T10:09:50.034-04:00Apex security and updatable views (2)In my previous post, I indicated that the code for table API's and instead of triggers can easily be generated.
The code generator takes the Apex generated table API package as the basis, not the table definition. I don't know if Apex can generate code for every column data type. If Apex doesn't generate code for some column, the following code generator won't either.
Before generating the Inohttp://www.blogger.com/profile/05100729748140066283noreply@blogger.com0tag:blogger.com,1999:blog-1833101781101822420.post-71598429445624295332011-02-04T14:34:00.010-04:002011-02-09T12:38:27.711-04:00Apex security and updatable views (1)Jeez, no post in 2010 at all! Time for a new one then.A lot of the basics in this post are derived from this very good presentation by Scott Spendolini (Secure Apex Development).In this presentation Scott basically shows how to use a separate schema, i.e. separate from your actual data schema, for building Apex applications. This shadow schema, as he calls it, contains just read only views and Inohttp://www.blogger.com/profile/05100729748140066283noreply@blogger.com0tag:blogger.com,1999:blog-1833101781101822420.post-3279238299769009292009-10-13T11:35:00.006-04:002009-10-16T16:44:26.856-04:00Override Apex CSS styleI was struggling with this for a long time before I found a simple solution. I just wanted to override a particular CSS style for one page. The style in the CSS file is defined as:.t14Standard td.t14data{border:1px solid #AAA;border-left:none;border-top:none;}I wanted to change this to:.t14Standard td.t14data {border:1px solid #AAA;border-left:none;}Sounds easy if you know how inheritance and Inohttp://www.blogger.com/profile/05100729748140066283noreply@blogger.com0tag:blogger.com,1999:blog-1833101781101822420.post-55246167265515262292009-07-31T14:30:00.011-04:002009-08-03T14:49:08.312-04:00Multiple tabular forms on one Apex pageAs you probably know, you cannot have multiple tabular forms on one Apex page. One way around this limitation is to create your own reports and processes. This is described in Denes Kubicek's multiple tabular forms example.But you can also trick your application to make it look like two tabular forms are on the same page.This page actually consists of two pages. The form at the bottom is defined Inohttp://www.blogger.com/profile/05100729748140066283noreply@blogger.com0tag:blogger.com,1999:blog-1833101781101822420.post-34176463156376061592009-07-30T14:18:00.009-04:002009-07-30T14:43:41.383-04:00Password item in a tabular Apex formIn a tabular form it is not possible to choose password as the display type. This means that a tabular form would look like this:This post by Patrick Wolf shows how you can add a check box to tabular forms. That gave me an idea to try the same thing for password items. It is actually much simpler than in Patrick's example!All you have to do is set the HTML expression of the item to:As explained Inohttp://www.blogger.com/profile/05100729748140066283noreply@blogger.com0tag:blogger.com,1999:blog-1833101781101822420.post-72668169003813736082009-07-06T19:30:00.016-04:002009-07-06T23:00:05.757-04:00Create an Audit Region based on a PL/SQL RegionIn my APEX application I wanted to have a small region in all screens which would enable the user to see the audit columns CREATED, CREATEDBY, UPDATED and UPDATEDBY which are present in all tables. Like the screenshot below shows, in the report I added a dummy column “Audit” with a link. When the user clicks on the audit link in a record, the Audit window in the upper right hand corner appears Unknownnoreply@blogger.com0tag:blogger.com,1999:blog-1833101781101822420.post-36540339171653867442009-06-17T12:46:00.004-04:002009-06-18T14:03:46.572-04:00This is just funnyOK, this is not a new tip or anything, but some weird translation of a previous post. I found this via Google. The original page was already removed from the web, but Google still had this in it's cache. Try to understand this:More Oracle Tips: Forms-Apex IntegrationThere are restful slews of companies that usage client/server Forms6i. For account of those companies I was asked to impute a form Inohttp://www.blogger.com/profile/05100729748140066283noreply@blogger.com0tag:blogger.com,1999:blog-1833101781101822420.post-8374105769706945772009-04-24T10:24:00.002-04:002009-04-24T10:56:41.337-04:00Forms-Apex Integration (3)In previous posts I gave a simple example how to display a stored PDF document from a Forms 6i client/server application using Apex. In this case it is not really necessary to create an Apex page, since you can call the stored procedure directly from the mod_plsql gateway. If you are not using an Apex page, you need to program some extra lines in your code for error handling.If you are using an Inohttp://www.blogger.com/profile/05100729748140066283noreply@blogger.com0tag:blogger.com,1999:blog-1833101781101822420.post-11488735892416446182009-04-03T12:33:00.018-04:002009-04-04T14:59:53.458-04:00Forms-Apex Integration (2)(PS: I am using SyntaxHighlighter for the first time. It works for IE, but not for Firefox, yet.PS2: I fixed the Firefox issue. Apparently Firefox cannot interpret a css file on googlecode. The trick is to include the css in the blogger template.)Yesterday I posted a simple solution for viewing stored PDF documents in a Forms6i client/server application using Apex. There was one catch: it was notInohttp://www.blogger.com/profile/05100729748140066283noreply@blogger.com0tag:blogger.com,1999:blog-1833101781101822420.post-14353409903284711052009-04-02T12:03:00.010-04:002009-04-17T09:02:43.726-04:00Forms-Apex IntegrationThere are still plenty of companies that use client/server Forms6i. For one of those companies I was asked to make a form to display PDF documents that are stored in the database. Well, you can save the file to a public directory on the database server and open this file with Acrobat Reader.I found it more challenging to see if I could integrate client/server Forms with Apex. Not surprisingly, itInohttp://www.blogger.com/profile/05100729748140066283noreply@blogger.com0tag:blogger.com,1999:blog-1833101781101822420.post-59336627095019723072009-02-18T20:45:00.017-04:002009-03-16T17:17:36.931-04:00Drag and Drop Shopping CartAt SQL Integrator we are just beginning to explore the possibilities of Apex. We do that by teaching each other via workshops. When somebody dives into a subject, he presents the result to the other Apex workshop participants. A good way to learn Apex.I had no idea how to do anything with Ajax. After some web surfing (mainly at w3schools.com) I tried some simple examples myself. Most of them Inohttp://www.blogger.com/profile/05100729748140066283noreply@blogger.com0tag:blogger.com,1999:blog-1833101781101822420.post-20681056052665459832009-02-17T12:23:00.014-04:002009-07-27T13:38:59.383-04:00JasperReports in ApexA lot of people complain that Oracle integrated the very expensive BI Publisher in Apex. Of course there are alternatives, like the open source JasperReports. But how do you use this?Jasper is completely new to me, so I started with a simple example. What you need is:Oracle Apex (of course)JasperServeriReportJasperServer and iReport can de downloaded from the Jaspersoft website.Basically, iReportInohttp://www.blogger.com/profile/05100729748140066283noreply@blogger.com0tag:blogger.com,1999:blog-1833101781101822420.post-50173424554148641642009-02-17T11:58:00.003-04:002009-02-17T12:10:55.600-04:00Welcome to yet another blogWell, like so many others nowadays, I think it is time to share some good tips&trics on Oracle. My colleagues and I have started a new track with Oracle Apex after many years of using Forms, Reports and Designer.Yep, we have tried JDeveloper and JHeadstart, and we discarded it. It seems way too complicated for most regular business type applications that focus mainly on data retrieval and Inohttp://www.blogger.com/profile/05100729748140066283noreply@blogger.com0