Home » Developer & Programmer » Forms » Problem with deleting records (Oracle Forms 11g, Windows/Linux)
Problem with deleting records [message #552599] Thu, 26 April 2012 16:26 Go to next message
p_pml
Messages: 15
Registered: February 2012
Junior Member
I noticed some strange behaviour in Forms 11g after migration from Forms 6i.

I had some datablock supplied with table A, this datablock has KYE-DELREC trigger (related with button for deleting record form datablock). In body of this trigger I had delete_record built-in statement used and underneath usual SQL command DELETE FROM A. In Forms 6i there was no problem, but after migration to Forms 11g (and Oracle database 11g) I am not able to delete any record form this table, because I am getting FRM-40510 (Unable to delete...) error during committing form.

When I removed this DELETE FROM A, everything start to work fine. But what is the reason of that kind of behaviour, what could be an explanation ?

Report message to a moderator

Re: Problem with deleting records [message #552601 is a reply to message #552599] Thu, 26 April 2012 17:47 Go to previous messageGo to next message
perry0511
Messages: 5
Registered: April 2012
Junior Member
A fatal error occurred while trying to delete 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.

Oracle error database FRM-40510

[Updated on: Thu, 26 April 2012 18:19]

Report message to a moderator

Re: Problem with deleting records [message #552637 is a reply to message #552601] Fri, 27 April 2012 02:47 Go to previous messageGo to next message
cookiemonster
Messages: 13925
Registered: September 2008
Location: Rainy Manchester
Senior Member
Why have you got the delete statement there at all?
delete_record deletes a record in the table that corresponds to the current record in the block. So why have the other delete?

Report message to a moderator

Re: Problem with deleting records [message #552642 is a reply to message #552637] Fri, 27 April 2012 03:04 Go to previous messageGo to next message
cookiemonster
Messages: 13925
Registered: September 2008
Location: Rainy Manchester
Senior Member
In addtion, when you get the error - go to the form run time help menu and click on Display Error.
That'll show the underlying oracle error that caused the delete to fail.

Report message to a moderator

Re: Problem with deleting records [message #552777 is a reply to message #552642] Sat, 28 April 2012 05:07 Go to previous messageGo to next message
p_pml
Messages: 15
Registered: February 2012
Junior Member
Display_error shows me the same message.

I think similar that this additional usual plsql "delete" is redundant, but let's say that this code was inherited and I have to justify why and what for I want to change core code.

Report message to a moderator

Re: Problem with deleting records [message #552780 is a reply to message #552777] Sat, 28 April 2012 05:37 Go to previous messageGo to next message
cookiemonster
Messages: 13925
Registered: September 2008
Location: Rainy Manchester
Senior Member
If the code is redundant, then it's wrong.
Do you need a better justification?

Report message to a moderator

Re: Problem with deleting records [message #552786 is a reply to message #552780] Sat, 28 April 2012 06:48 Go to previous messageGo to next message
p_pml
Messages: 15
Registered: February 2012
Junior Member
That is true, but the owner of the forms application is strongly oversensitive in case of changing "core code" and has problems with understanding that after migration to Forms 11g the same code is working wrong. In other words, he requires more "scientific" explanation, f.e. what has changed in Forms engine, some Oracle datasheet info or something like that. I searched Oracle support (former Metalink) but I didn't find anything corresponding to that.

Report message to a moderator

Re: Problem with deleting records [message #554526 is a reply to message #552786] Tue, 15 May 2012 03:28 Go to previous messageGo to next message
sinida1984
Messages: 83
Registered: September 2007
Location: India
Member
Hi

I had a similar problem after 11g migration. After logon in some forms the data was not getting queried. The solution was

After 11g migration the logon is case sensitive by default.

Alter system set sec_case_sensitive_logon = FALSE command will set the logon not case sensitive. Please try the same old code after executing the command.


Regards
Sinida.

Report message to a moderator

Re: Problem with deleting records [message #554576 is a reply to message #554526] Tue, 15 May 2012 12:41 Go to previous messageGo to next message
joy_division
Messages: 4963
Registered: February 2005
Location: East Coast USA
Senior Member
sinida1984 wrote on Tue, 15 May 2012 04:28
Hi

I had a similar problem after 11g migration. After logon in some forms the data was not getting queried. The solution was

After 11g migration the logon is case sensitive by default.

Alter system set sec_case_sensitive_logon = FALSE command will set the logon not case sensitive. Please try the same old code after executing the command.


But the problem does not seem to be a problem with not being able to login. It is a redundant DELETE.

Report message to a moderator

Re: Problem with deleting records [message #554597 is a reply to message #554576] Tue, 15 May 2012 22:42 Go to previous message
sinida1984
Messages: 83
Registered: September 2007
Location: India
Member
Hi

The logon was successful for me also. While in some forms 'execute_query'/SELECT clauses etc. was not working, then only we found that logon will be successful with other unexpected errors. And the issue occurred only in some forms.

Thanks
Sinida

Report message to a moderator

Previous Topic: Scrollbar & disabled button issue
Next Topic: What Does a Return Value of 5 Indicate for app item property.get property?
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Fri Jul 05 22:06:55 CDT 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.