To develop these forms and manage transactions within the database was VERY cumbersome.
APEX is a great framework which allows you to define all parts of the form declaratively. It also has many more features and abilities for formatting, validations, session state etc.
I think you will find that the effort taken to create a PL/SQL procedure that generates a HTML form can quickly and easily be created within a few minutes in the APEX Wizards.
I would say it is better to re-create each of your forms using the APEX framework as you will find many more features. This should be quite easy to do a Proof-of-Concept if you already have the database table definitions from your Portal Database.
Have you had a look at some of the form samples on apex.oracle.com?
1 person found this helpful
I had stale Portal/mod_plsql skills when I started to learn APEX and as Amanda says - it's really easy compared to Portal.
APEX handles the GUI through wizards and manipulating declarative attributes, and much faster to do so.
You may have some existing PL/SQL that could be used, if they are data specific processes like processing emails or something.
And the SQL that define your reports could also be salvaged.
Portal's flame burnt quick but bright, APEX has a longer future.
Thanks for your insight. Yes, I did take a look at some form samples on Oracle website.
I also looked at the procedures that was generated by the Oracle Portal webDB and there were one of our dba suggested to run the same code in APEX but what I found, was that these procedures were generated by webDB Portal and may not be able to run in APEX because it is a different architecture.
I agree with you, the best solution is to recreate the forms and reports that was generated by the procedures.
Now, the implementation of this application was a search application that was using a stem and fuzzy search to search the Oracle Database. do you know any good documentation that will allow me to learn more about this type of search and how to implement that in APEX?
I agree, thanks for your thought and I appreciate your time to stop by and give me your insight on this matter.
Sorry I have not implemented a stem and fuzzy search functionality in APEX.
The most comlex "Search" functionality I have implemented in an application is similar to what you will find in the 'Sample Search' packaged application on apex.oracle.com.
I would suggest you start a new post with a title specific to your search requirements and see if there are some experts on the APEX forum that have implemented something similar to what you are looking for.