OraFAQ Forum: Forms » find all database objects in a form

Home » Developer & Programmer » Forms » find all database objects in a form

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

find all database objects in a form [message #172452]

Tue, 16 May 2006 09:56

kritikverma
Messages: 22
Registered: January 2006
Location: Jamshedpur, India

Junior Member

I want a way to find all the database objects in a form that is used anywhere in the forms. These database objects include tables, views, synonyms, procedures, functions etc.
I have the source file i.e. fmb and fmx as well.

Please help.

Kriti

Report message to a moderator

Re: find all database objects in a form [message #172489 is a reply to message #172452]

Tue, 16 May 2006 18:53

djmartin
Messages: 10181
Registered: March 2005
Location: Surges Bay TAS Australia

Senior Member
Account Moderator

Have a look at http://www.orafaq.com/forum/m/161903/67467/?srch=FIRST_BLOCK#msg_161903

David

Report message to a moderator

Re: find all database objects in a form [message #172526 is a reply to message #172489]

Wed, 17 May 2006 01:47

Maaher
Messages: 7065
Registered: December 2001

Senior Member

I'm thinking that perhaps the JDAPI (Java Design-time API) can help you out. It would mean though that you have to investigate:
- block properties
- triggers
- program units
- record groups
...

Once you've written your Java program it is reusable. I've written a program once to extract all PL/SQL code from a Form to store it in the database.

MHE

Report message to a moderator

Re: find all database objects in a form [message #172687 is a reply to message #172526]

Wed, 17 May 2006 11:46

vijaykkiran
Messages: 5
Registered: April 2006

Junior Member

try out this query in the sql prompt..

sql> select object_name,object_type from user_objects order by object_type;

this will display all the objects created in the current user_schema level.. so what are the objects created in that user it will display all of them.. for more columns in that table use this ..
sql> desc user_objects;

from this u can see more details of that objects...

Report message to a moderator

Re: find all database objects in a form [message #172792 is a reply to message #172687]

Thu, 18 May 2006 01:50

Maaher
Messages: 7065
Registered: December 2001

Senior Member

@vijaykkiran: that's not the question here. kritikverma wants to know what objects are used in a Form module, i.e. know the dependencies.

MHE

Report message to a moderator

Re: find all database objects in a form [message #172861 is a reply to message #172792]

Thu, 18 May 2006 07:11

djmartin
Messages: 10181
Registered: March 2005
Location: Surges Bay TAS Australia

Senior Member
Account Moderator

Maarten,

Isn't he just trying to do a scan of all the blocks and each of their items, then determine which are database items and which are not?

David

Report message to a moderator

Re: find all database objects in a form [message #172885 is a reply to message #172861]

Thu, 18 May 2006 08:22

Maaher
Messages: 7065
Registered: December 2001

Senior Member

Ok, now I'm confused.

kritikverma, can you explain what you are trying to accomplish here? The part "that is used anywhere in the forms" triggered my initial reply but I might be wrong...

MHE

Report message to a moderator

Previous Topic:	Diff between CALL_FORM and PARLIST
Next Topic:	how use input box

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri Sep 20 06:25:05 CDT 2024