Re: Capture INSERT statement from DEV2000??

From: Dan Townsend <townsend_at_ebmud.com>
Date: 1997/03/31
Message-ID: <33400316.554D_at_ebmud.com>#1/1

Using the Display Error function just after the error occurs usually shows the actual SQL Oracle*Forms generated that caused the error. In rare cases, you might have to turn statistics on, get the error, then go looking for the trace file. This is usually only necessary if the error is occurring in user-written SQL versus forms-generated SQL.

+-----------------------------------------------------
| Dan Townsend, Supervising Database Architect

| EBMUD Enterprise Object Designer
| mailto:townsend_at_ebmud.com

+-----------------------------------------------------

Clyde Taeger wrote:
>
> Does anyone out there have any idea as to how I can capture the INSERT
> statement Dev2000 sends to the back end prior to the actual INSERT. It
> would have much easier to isolate the problem by taking that statement and
> passing it through SQL Plus instead.
>
> Thanks.
Received on Mon Mar 31 1997 - 00:00:00 CEST