CODEWITHSUNDEEP
oracle-databaseoracle10goracleforms
Amir
Amir

Reputation: 1979

How to find oracle forms dependency

I have 20 forms which I want to find all the dependency of them, would you mind help me please?

For instance if these forms using same table show me a dependency among them. actually I want to do some major changes backend so I am worry it hit error.

Is there any free software?

I found this but it is not working I am receiving an error..

my forms version is 6i.

 Program Dump: 17/11/2011 12:54:25 Error ID:
 8WHR2sgAEtLWMbuDUODvrAJFmxCc12MoH1iADR4kdqzqRDfJMKy2Yulm76jMX2BGUBLUbHiDG4Y=
 Main

 Error: Exception has been thrown by the target of an invocation.    at
 System.RuntimeType.CreateInstanceImpl(Boolean publicOnly)    at
 System.Activator.CreateInstance(Type type, Boolean nonPublic)    at
 Rhea.LicenseKey.RunProgram(String site, String serial, Type
 mainObject)    at DependencySearcher.FrmMain.Main(String[] args)

 Program Dump: 17/11/2011 12:54:41 Error ID:
 8WHR2sgAEtLWMbuDUODvrAJFmxCc12MoH1iADR4kdqzqRDfJMKy2Yulm76jMX2BGUBLUbHiDG4Y=
 Main

 Error: Exception has been thrown by the target of an invocation.    at
 System.RuntimeType.CreateInstanceImpl(Boolean publicOnly)    at
 System.Activator.CreateInstance(Type type, Boolean nonPublic)    at
 Rhea.LicenseKey.RunProgram(String site, String serial, Type
 mainObject)    at DependencySearcher.FrmMain.Main(String[] args)

 Program Dump: 17/11/2011 15:20:44 Error ID:
 8WHR2sgAEtLWMbuDUODvrAJFmxCc12MoH1iADR4kdqzqRDfJMKy2Yulm76jMX2BGUBLUbHiDG4Y=
 Main

 Error: Exception has been thrown by the target of an invocation.    at
 System.RuntimeType.CreateInstanceImpl(Boolean publicOnly)    at
 System.Activator.CreateInstance(Type type, Boolean nonPublic)    at
 Rhea.LicenseKey.RunProgram(String site, String serial, Type
 mainObject)    at DependencySearcher.FrmMain.Main(String[] args)

 Program Dump: 18/11/2011 16:59:26 Error ID:
 8WHR2sgAEtLWMbuDUODvrAJFmxCc12MoH1iADR4kdqzqRDfJMKy2Yulm76jMX2BGUBLUbHiDG4Y=
 Main

 Error: Exception has been thrown by the target of an invocation.    at
 System.RuntimeType.CreateInstanceImpl(Boolean publicOnly)    at
 System.Activator.CreateInstance(Type type, Boolean nonPublic)    at
 Rhea.LicenseKey.RunProgram(String site, String serial, Type
 mainObject)    at DependencySearcher.FrmMain.Main(String[] args)

Upvotes: 1

Views: 1526

Answers (2)

jvs
jvs

Reputation: 1

ODA - Orale Dependencies Analyzer. This tool gives all answers about Oracle form dependencies.

Upvotes: 0

APC
APC

Reputation: 146229

There is a Forms API which allows us some programmatic access to the Forms source. The original API, introduced in Forms 5.0, was written in C but Oracle did release a Java version of it. I can't remember when that was, but it was available for Forms 6i. Search your Forms installation for "jdapi".

The other thing you can do is run the Forms to XML converter. This generates an XML version of the source, which you can then search for Table Names.

Sorry this is a bit vague, but it has been a decade since I last used Forms 6i. Which reminds me, Forms 6i was a good tool in its day but its day was a long time ago, from the day when the internet was much smaller, online information is hard to find. And of course it has long since fallen out of support.

Upvotes: 3

Related Questions