Home » SQL & PL/SQL » Client Tools » Is there any tool avilable to find out the name of the Stored Procedure/Function/Package?
Is there any tool avilable to find out the name of the Stored Procedure/Function/Package? [message #381717] Mon, 19 January 2009 06:57 Go to next message
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?
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 Go to previous messageGo to next message
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.
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 Go to previous messageGo to next message
BlackSwan
Messages: 25046
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.
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 Go to previous messageGo to next message
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.
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 Go to previous messageGo to next message
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?
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 Go to previous messageGo to next message
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
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 Go to previous messageGo to next message
BlackSwan
Messages: 25046
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.
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 Go to previous message
Littlefoot
Messages: 20900
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.
Previous Topic: Database Schema
Next Topic: TOAD 9.6.1.1. - Schema Browser - Tablespaces TAB
Goto Forum:
  


Current Time: Thu Dec 08 04:24:31 CST 2016

Total time taken to generate the page: 0.08477 seconds