Google Groups no longer supports new Usenet posts or subscriptions. Historical content remains viewable.
Dismiss

what book for 9i or 10g forms?

4 views
Skip to first unread message

David Shochat

unread,
Dec 25, 2009, 3:05:37 PM12/25/09
to
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

Mark D Powell

unread,
Dec 25, 2009, 10:19:23 PM12/25/09
to

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 --

Shakespeare

unread,
Dec 27, 2009, 5:06:55 AM12/27/09
to
Mark D Powell schreef:

You may have run into bug 338834.1; see metalink. A patch is available.

Shakespeare

David Shochat

unread,
Dec 28, 2009, 1:49:00 PM12/28/09
to
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

0 new messages