what book for 9i or 10g forms?
in [Oracle Help]
|
Prev: usage of calculated index with a synonym for the function
Next: Oracle Connect Newsletter – December 2009 Issue
From: David Shochat on 25 Dec 2009 15:05 I am doing maintenance on a 9i forms application that we are migrating to 10g. It mostly works without change, except for a FRM-92100 exception that did not occur under 9i. In order to debug this, I need to better understand how control flow actually works, e.g., the order in which the various code fragments execute. I can tell that I need a resource that will teach me the fundamentals. Any suggestions? Thanks -- David
From: Mark D Powell on 25 Dec 2009 22:19 On Dec 25, 3:05 pm, David Shochat <shoch...(a)yahoo.com> wrote: > I am doing maintenance on a 9i forms application that we are migrating to > 10g. It mostly works without change, except for a FRM-92100 exception > that did not occur under 9i. In order to debug this, I need to better > understand how control flow actually works, e.g., the order in which the > various code fragments execute. I can tell that I need a resource that > will teach me the fundamentals. Any suggestions? Thanks > -- David I noticed that Older documentation sets are available online at http://tahiti.oracle.com and you might look there for 9i Forms documentation. It also occurs to be that the database session SQL trace feature might be of some use if you trace your session. The raw trace will shoe the SQL executed in the order it executed which would allow you to tie SQL back to the actions your took. Good luck. HTH -- Mark D Powell --
From: Shakespeare on 27 Dec 2009 05:06 Mark D Powell schreef: > On Dec 25, 3:05 pm, David Shochat <shoch...(a)yahoo.com> wrote: >> I am doing maintenance on a 9i forms application that we are migrating to >> 10g. It mostly works without change, except for a FRM-92100 exception >> that did not occur under 9i. In order to debug this, I need to better >> understand how control flow actually works, e.g., the order in which the >> various code fragments execute. I can tell that I need a resource that >> will teach me the fundamentals. Any suggestions? Thanks >> -- David > > I noticed that Older documentation sets are available online at > http://tahiti.oracle.com and you might look there for 9i Forms > documentation. > > It also occurs to be that the database session SQL trace feature might > be of some use if you trace your session. The raw trace will shoe the > SQL executed in the order it executed which would allow you to tie SQL > back to the actions your took. > > Good luck. > > HTH -- Mark D Powell -- You may have run into bug 338834.1; see metalink. A patch is available. Shakespeare
From: David Shochat on 28 Dec 2009 13:49
On Sun, 27 Dec 2009 11:06:55 +0100, Shakespeare wrote: > Mark D Powell schreef: [snip] >> >> I noticed that Older documentation sets are available online at >> http://tahiti.oracle.com and you might look there for 9i Forms >> documentation. >> >> It also occurs to be that the database session SQL trace feature might >> be of some use if you trace your session. The raw trace will shoe the >> SQL executed in the order it executed which would allow you to tie SQL >> back to the actions your took. >> >> Good luck. >> >> HTH -- Mark D Powell -- > > You may have run into bug 338834.1; see metalink. A patch is available. > > Shakespeare Thanks, Mark and Shakespeare. I will look into that bug when I get back to work on 1/4. Meanwhile, I found this page (Google "oracle 9i DS" I think): http://www.oracle.com/technology/products/forms/techlisting9i.html Which contained the following link under "Tips, Techniques and Debugging", which has the kind of information I was looking for: http://www.oracle.com/technology/products/forms/pdf/forms9idiagnostics.pdf |