OraFAQ Forum: Client Tools » Is there any tool avilable to find out the name of the Stored Procedure/Function/Package?

Home » Other » Client Tools » Is there any tool avilable to find out the name of the Stored Procedure/Function/Package?

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

Is there any tool avilable to find out the name of the Stored Procedure/Function/Package? [message #381717]

Mon, 19 January 2009 06:57

gurupatham
Messages: 66
Registered: March 2008
Location: Chennai

Member

Is there any tool available to find out the name of the Stored Procedure/Function/Package that are used in a Forms?

Report message to a moderator

Re: Is there any tool avilable to find out the name of the Stored Procedure/Function/Package? [message #382047 is a reply to message #381717]

Tue, 20 January 2009 14:44

andrew again
Messages: 2577
Registered: March 2000

Senior Member

if you have your form code in some flat file format, then it make be easiest to search for some patern in the file. grep would be the obvious choice on Unix.

Report message to a moderator

Re: Is there any tool avilable to find out the name of the Stored Procedure/Function/Package? [message #382049 is a reply to message #381717]

Tue, 20 January 2009 14:49

BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal

Senior Member

> grep would be the obvious choice on Unix.
How do you determine what string to grep for?
If you already have a list of procedure names, the original problem has already been solved.

Report message to a moderator

Re: Is there any tool avilable to find out the name of the Stored Procedure/Function/Package? [message #382060 is a reply to message #382049]

Tue, 20 January 2009 15:46

andrew again
Messages: 2577
Registered: March 2000

Senior Member

you'd try to get an understanding of the flat file structure to see if you can determine the text preceeding and following a (pl/sql block I guess?) that calls a package/proc/function. It's not a trivial approach at all and you need to cater for all the places in a form that you could call a package/proc/function.

Report message to a moderator

Re: Is there any tool avilable to find out the name of the Stored Procedure/Function/Package? [message #382104 is a reply to message #382049]

Wed, 21 January 2009 00:06

gurupatham
Messages: 66
Registered: March 2008
Location: Chennai

Member

What Andrew said is correct.We are strictly following the naming conversion like all Strored procedure Should start with Some Specific character.So we can easily search. But the problem is while converting fmb to text file by using the following Script, It Converts only the name of the procedures/functions/package of program Units to text file not the content(Source) of the procedure/function/package.

for %%f in (*.fmb) do start  /min /wait ifcmp60 module=%%f Logon=no module_type=form batch=yes script=yes  forms_doc=yes

Is there any way to convert the whole content(Source) of the program Units to flat file format?

Report message to a moderator

Re: Is there any tool avilable to find out the name of the Stored Procedure/Function/Package? [message #382143 is a reply to message #381717]

Wed, 21 January 2009 02:48

dr.s.raghunathan
Messages: 540
Registered: February 2008

Senior Member

if forms are created as pages through apex 3.1.2, anyone can be able to see the stored procedures functions on editing the pages. All the stored procedurs / functions / packages involving the schemas as objects shall also be seen using the object browser in Oracle XE.
yours
dr.s.raghunathan

Report message to a moderator

Re: Is there any tool avilable to find out the name of the Stored Procedure/Function/Package? [message #382252 is a reply to message #381717]

Wed, 21 January 2009 09:29

BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal

Senior Member

>ifcmp60
Forms 6? (as in client/server?)
If so, has been obsoleted for a number of years
& IIRC has not been supported this century.

Report message to a moderator

Re: Is there any tool avilable to find out the name of the Stored Procedure/Function/Package? [message #382292 is a reply to message #382252]

Wed, 21 January 2009 15:42

Littlefoot
Messages: 21823
Registered: June 2005
Location: Croatia, Europe

Senior Member
Account Moderator

Which, of course, doesn't necessarily have to mean that Forms 6 based applications still aren't in use worldwide.

Report message to a moderator

Previous Topic:	Database Schema
Next Topic:	TOAD 9.6.1.1. - Schema Browser - Tablespaces TAB

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri Feb 07 01:24:20 CST 2025