Skip to Main Content

Oracle Forms

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!

How to determine DataBase items from within Form Builder?

97967Jan 22 2008 — edited Jan 22 2008
I am in the mist of attempting to upgrade a Oracle Forms version 5 application into a oracle forms 6i application. (I am doing this so I can at least run the application on my own machine to dissect and analysis it. I am using forms 6i because most information posted says to upgrade all pre 6i forms to 6i first, and because forms 6i runs a whole lot better on my machine than forms 10g which is extremely slow and is constantly crashing )

I had source code, which I couldn't run - but runs on some clients machines. When the clients runs the app it runs against a production database schema.
I have read-only access to that production schema, but I can't and shouldn't attempt to run the program to actually alter any production data.

I am unsure which tables and other items, as defined in the production schema, are actually used by the application.

I do have a oracle 'sandbox' where I have (almost) full dba privileges. So what I have been doing is this:
1) Compile the form in Forms builder, and use the errors to identify missing components such as tables or packages.
2) In TOAD connected to the prod area, I use it's 'create script' function, to generate a create script for the missing item.
3) In TOAD again, in the sandbox area, I modify the script slightly ( different table spaces ) and run it to create the items in the sandbox schema.
After a lot of compile, break and fix cyles, I identified several tables
4) I then return to step 1 and repeat...

I got a clean compile from Forms ( using the compile all menu item ), but when I run it and am getting additional compile errors ( why since I already compiled all ? ).

So I am continuing to identify the missing item by this "break and fix" method, but isn't there a way for FORMS to tell me all the database schema object it is expecting to see defined? The navigator, when connected to the database just shows EVERYTHING (not just what is being used) and when not connected it shows nothing ( not what it needs ).

So Is there a easier way to figure out EXACTLY what tables, procedures, etcetera the FORMS application is wanting to be defined in the schema all at once?
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Feb 19 2008
Added on Jan 22 2008
2 comments
811 views