Capture INSERT statement from DEV2000??

[Quoted] [Quoted] I have a question related to Developer 2000 / Personal Oracle. Recently I [Quoted] wasted about 5 Hours trying to figure out why I was unable to save a record in a Form. When ever I tried to save a new record, I got the message:

'FRM-40508 ORACLE error: Unable to INSERT record.'

Referring back to the useful on-line help this means:  'A fatal error occurred while Oracle Forms was trying to insert a record. The table associated with the current block of the form might not exist, your username might not have authority to perform the specified action on the table, or some other reason might have caused the fatal error.

It quickly became evident to me based on the above explanation that it could have been anything. Try debugging this, where the heck do you start.  Anyway, to make a long story short, I ended up removing all fields that were not imposed as mandatory columns by the back end from the form until there were only two fields left - and still the same problem. It turned out that one of the properties associated to a column on the form was inadvertently set to 'QUERY ONLY'. This means that when Oracle Forms does an update or insert on a record it only passes columns to the back end which have this property set to false and since one of the columns on the form was part of the primary key I got that Error message.

[Quoted] [Quoted] Does anyone out there have any idea as to how I can capture the INSERT [Quoted] 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 [Quoted] passing it through SQL Plus instead.

Thanks. Received on Fri Mar 28 1997 - 00:00:00 CET