Post Changes causing error

[Randy Jones]

I just recently updated to 7.1.5.1397 and I now can't seem to update directly in the SQL Window via the edit command.

I select some data with the rowid, to qualify it for a data edit. I then click on the edit button, and as always it adds that row down below (the one with an asterisk on the left hand side), in case I'm adding new data. Since I'm just doing an update I click on the record I'm trying to update and change a flag from T to F. I then try to Post the changes and I get an Oracle Error that the flag can not be null. It's not Null, it's F...but there is that row below, is that what it's trying to insert with the null? Anyway, I can't get the Edit Data feature to work I have to just discard the changes. I'm having to resort back to straight DML!

Please help. Thanks!

 

[Marco Kalter]

I cannot reproduce this. To obtain some more diagnostic information, can you modify the shortcut and add the debugsql parameter? For example:

"C:\Program Files\PLSQL Developer\plsqldev.exe" debugsql

Reproduce the problem and send me the debug.txt file that is generated in the PL/SQL Developer directory.

 

[Randy Jones]

Sorry for the delay, I was going to run the debug today, but then I saw you had a new patch. I patched to 7.1.5.1398 and the problem is no longer occurring. A fellow coworker verified it was fixed on his system as well after he patched.

 

[Marco Kalter]

Okay, thanks for letting me know.