Home » Developer & Programmer » Forms » strange FORMS behavior (WebForms with Oracle DB 10.2.0.5)
strange FORMS behavior [message #515813] Wed, 13 July 2011 07:33 Go to next message
HoJo
Messages: 1
Registered: July 2011
Junior Member
Hi,

we have a very strange behavior in our FORMS client.
Last weekend we upgraded our database from 10.2.0.4 to 10.2.0.5 and we upgrade to AIX 6.1 on the database server. Since then we receive an error inside one FORMS screen:
Cannot insert into or update data in a view.

Now as I said, this screen was always working and we didn't do any change at the FORMS client.

Another thing is, that we don't want to update the data via a view. Of course the data block got created on a view, but the update, insert and delete should happen via stored procedures that are set inside the FORMS data block properties.

I hope someone can help us here.

Thanks in advance
br Holger

Report message to a moderator

Re: strange FORMS behavior [message #515816 is a reply to message #515813] Wed, 13 July 2011 07:57 Go to previous messageGo to next message
cookiemonster
Messages: 13937
Registered: September 2008
Location: Rainy Manchester
Senior Member
If you're using procedures for insert/update/delete why aren't you using a procedure for query?
That's what I would have done.

Report message to a moderator

Re: strange FORMS behavior [message #515855 is a reply to message #515816] Wed, 13 July 2011 11:44 Go to previous message
Littlefoot
Messages: 21818
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
Or, if you based the block on a view, why don't you do inserts/updates/deletes via INSTEAD OF trigger?

Report message to a moderator

Previous Topic: Button next_record doesn't work
Next Topic: auto populating records in other fields based on the inventory no. field
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Sun Sep 08 23:01:06 CDT 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.