Monday, May 4, 2009

COLLABORATE 09: Convert Forms to ApEx

David Peake
Oracle Application Express 3.2 Forms Conversion

Stupid laptop battery. This would have been done during.

Anyway, it was a tad depressing to see this presentation. All ApEx all the time. The first 20 minutes were an overview of ApEx. Yeah, I know, it's cool. Thanks for reminding me that I can't sell it to anyone. I had Miladin interested in it, but I left before we could really do anything.

I attended because my new place has Oracle Forms and there doesn't seem to be a lot of experience with them. The Forms Converter is part of the latest release, 3.2.

First, you convert your OLB or menu files using the forms2xml utility.
Next, create a workspace and associate it to your Forms application schema.
Create a conversion project.
Analyze the Oracle Forms application.
Generate the Oracle ApEx application.

Voila! You're done. Now all you have to do is customize to suit your needs. Very nice stuff indeed.

You can find a tutorial on Oracle-by-Example (OBE) here.

No comments: