PITSS Tech BlogNews zu Java, PL/SQL, Entwicklung & Technologiewechsel
Q&A Oracle APEX: Get your dream application
More than 200 participants in our webcast „Get your dream application with Oracle APEX“ confirm our feelings. For this overwhelming interest and great feedback, we would first like to thank you and Carsten Czarski from Oracle.
List of questions to APEX Development
Where can I get the best information for APEX development if an AD with LDAP is to be connected?
What structure and size an APEX application should have?
What kind of access my DBA needs to provide in order to start using APEX?
What is the procedure to take an existing Oracle Form and convert to APEX form?
We have Forms application with 600 forms and many reports. I am more curious at first about UI transformation. Forms use different UI paradigms based on multiple document interfaces. Obviously APEX is different and conversion of 600 forms into 600 pages is a silly idea. What common practises exist for UI transformation?
Is it possible to develop mobile apps with oracle APEX? If yes, how?
Is it cost effective and scalable as per requirement?
Is APEX suited for team development ? (30 developers on same application)
As an example, the APEX Application Builder is itself developed in APEX, consists of 2500 pages and is developed by 10-15 persons. The AppBuilder is divided into ca. 10 smaller subapps.
In such a big development team you should think about different responsibilities, UI, backend, JS, shared components, business areas. At least, you could lock pages for a developer, to avoid working in parallel on the same page.
A team of 30 developers for one application is a big team, especially if you remind, that APEX developers with the low code principles are very efficient.
How do I show customers that APEX is bullet-proof in the vulnerability test?
You could use a different set of security options, e.g. using HTTPS, rely on autorisation and authentication, controlling the session state, use hash values to avoid URL hacking, etc.
How to run a pdf report in Oracle APEX?
You could use an interactive grid or interactive report to generate PDF documents with ORDS or you could integrate classic report engines like Jasper, BIRT, AOP, PL/PDF or BI Publisher and even Oracle Reports to generate the output.
How do I implement Dashboards in Oracle APEX?
You could use components like charts, carts and other similar objects on your page.
How do I implement “non-base table items” in APEX?
If you use the non-base table item in a kind of computed column you could assign a similar function as a computation to the APEX element. If you want to have an element without binding this to a column of a select statement, you could bind the element to a PL/SQL procedure to react on any input.
How to handle themes, should you change them and why? What are the implications of changing themes in regards to future APEX upgrades?
This depends on the type of changes you’d like to adopt. If you only need to change CSS relevant parts, use the themeroler to change it. With this you stay in support of any new releases. If you have to change the HTML template, we advice to copy an existing template and adjust this. If a theme is updated by Oracle, you won’t benefit from them.
How much can I take advantage of when migrating an application from oracle forms and report to APEX?
How complicated is it to convert traditional Oracle FORMS to APEX app?
This depends on your development pattern you use in Oracle Forms. With an analysis we could identify very fast and failure free all obstacles, the save on investment and all remaining effort per Form module.
How Can I install APEX in an Oracle Express Local Machine?
No difference to other Oracle database products. Follow https://www.oracle.com/tools/downloads/apex-v191-downloads.html for Downloading and instructions for installation.
How could I control the order of dynamic actions?
Can we convert forms 6i to APEX? How efficient and how many customers have done so far?
Yes, there is no dependency to a specific Forms Version. There are a huge amount of customers in this situation, because with APEX you could transform your Client-Server Application into a modern WebApp without investing into WLS.
Best practises to call APEX from Forms and vice versa?
Is APEX suitable for large business?
This is no longer an issue. Even the updates and changes from the latest releases, like Faceted Search, Dynamic Actions, support of different master/detail scenarios, allow us to use APEX for large enterprise applications.
Is it better to rewrite existent forms applications or migrate them to APEX?
From our perspective, that is not really a question. Independent from the migration from Forms to APEX a migration in general provides the following advantages vs rewriting the code:
- Rewriting code and developing a fresh application often underestimate the errors, which occurs during the development.
- Projects for new software development often underestimate the time and cost perspective
- Rewriting needs to create a requirement specification, which is time consuming, failure effective, and difficult to realize.
- While rewriting an application you could step into the risk, to miss necessary requirements.
- Register new requirements considering the business process from a theoretical point of view. The existing app is business proved and you could focus on changes only.
The code we generate for APEX follows APEX best practices and looks hand made. The existing Forms Application is the best requirement document and after our preparation phase we could generate a very good starting point for the APEX development. New features and requirements could then be developed in APEX.
How could I read data from another database e.g. MSsql?
We use Oracle Designer and have added features, via forms library, that auto-generate journaling inquiry and our standard menu options/icons. Can these be implemented with Apex via a plug-in, library, or template?
How to implement file download on APEX Application? The file is located on the OS filesystem. Maybe plugin?
Can a page be imported to another application in the same workspace or different workspace?
Page exports are (at least currently) limited to the same app in the same workspace. If you plan on using page exports to transfer changes from Dev to Test or Prod, make sure that Workspace IDs are identical on all these systems. When creating a workspace, you can provide the workspace ID – so you can look up the workspace from PROD and create the DEV Workspace with the same ID. Then also make sure that Application IDs are equal on Dev and Prod. Once that all is in place, you can transfer pages from one environment to the other.
Will I be able to create Forms layout on remote database tables using DBLink. Can we develop APEX applications over DB Link to other databases?
Yes – APEX runs inside the Oracle Database. Your Form simply executes SQL and PL/SQL. And when your APEX components can execute a „select * from EMP“, it can also execute a „select * from emp@dblink“
Would like to see a demo of some of our forms converted to APEX
Use our Webinar Special!
Any question left?
Could you find all the answers to your questions on this page? If not, we will be happy to be there for you personally and clarify all open points. Just fill out the form below and we will get back to you as soon as possible.