OraFAQ Forum: Forms » Problem with deleting records

Home » Developer & Programmer » Forms » Problem with deleting records (Oracle Forms 11g, Windows/Linux)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Problem with deleting records [message #552599]

Thu, 26 April 2012 16:26

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

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

cookiemonster
Messages: 13963
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

cookiemonster
Messages: 13963
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

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

cookiemonster
Messages: 13963
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

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

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

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

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:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Mon Feb 03 02:09:34 CST 2025