Skip to Main Content

APEX

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Migrate/Import/[etc.] PL/SQL Web-Toolkit Application to APEX

596923Sep 8 2007 — edited Sep 12 2007
Hello all,

I've only recently learned about APEX and have dabbled with it for a little while, and I'm quite impressed with how amazingly quick it is to develop applications with it.

A few co-workers and myself are trying to convince "The Management" that we should pursue using APEX to develop our Enterprise Applications. Currently we write our web apps using the PL/SQL WebToolkit, accessing our applications at URL's like:
 http://host/dad/[package.]procedure 
.

Recently (within the past month) there was a convention in the Southern California region where I believe some people from TUSC presented on APEX. As I understand it, they said it was possible to migrate existing applications (written in packages and procedures) to APEX. I'm also told that it is possible to view the PL/SQL that is rendered by APEX to display the application.

We've practically sold our Director, however he has a few outstanding issues he's asked me to research, as he feels his boss would be most concerned with:

* How much effort will it take to migrate/import/etc the PL/SQL WebToolkit Application to APEX

* Should the need arise, how much effort would it take to move from APEX back to PL/SQL WebToolkit

I've tried researching these topics over the past few days and I haven't really come up with much. I realize that you can call PL/SQL packages/procedures/etc from within a region, but as I read on a thread in these forums ( 1609960 ), you still won't be able to take advantage of the Items, Computations, Processes, etc. Is there, in fact, a way of importing a PL/SQL-developed Web Application into APEX to take advantage of all its tools? I would imagine it would be quite a feat to be able to create the items for the form fields, maintain the layout and such, but I need to provide my Director with as much information on these topics as possible.

Many of us developers are really excited at the prospect of developing with this tool; it would be a shame to lose the opportunity over not being able to provide any information on the topics above.

Thanks in advance for your assistance,

-Luis
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Oct 10 2007
Added on Sep 8 2007
4 comments
767 views