tag:blogger.com,1999:blog-18331017811018224202012-01-13T15:36:47.346-04:00Inohttp://www.blogger.com/profile/05100729748140066283noreply@blogger.comBlogger131100tag:blogger.com,1999:blog-1833101781101822420.post-53693500872731666702011-02-09T12:34:00.003-04:002011-04-20T10:09:50.034-04:00

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:00

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:00

I 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.com1tag:blogger.com,1999:blog-1833101781101822420.post-55246167265515262292009-07-31T14:30:00.011-04:002009-08-03T14:49:08.312-04:00

As 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.com5tag:blogger.com,1999:blog-1833101781101822420.post-34176463156376061592009-07-30T14:18:00.009-04:002009-07-30T14:43:41.383-04:00

In 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:00

In 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

Sanderhttp://www.blogger.com/profile/01177469893026820892noreply@blogger.com0tag:blogger.com,1999:blog-1833101781101822420.post-36540339171653867442009-06-17T12:46:00.004-04:002009-06-18T14:03:46.572-04:00

OK, 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:00

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:00

(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 not

Inohttp://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:00

There 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, it

Inohttp://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:00

At 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:00

A 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, iReport

Inohttp://www.blogger.com/profile/05100729748140066283noreply@blogger.com22tag:blogger.com,1999:blog-1833101781101822420.post-50173424554148641642009-02-17T11:58:00.003-04:002009-02-17T12:10:55.600-04:00

Well, 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 entry.

Inohttp://www.blogger.com/profile/05100729748140066283noreply@blogger.com0