OraFAQ Forum: Forms » Please Help

Home » Developer & Programmer » Forms » Please Help

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

Please Help [message #148842]

Mon, 28 November 2005 10:06

gtrecart
Messages: 2
Registered: November 2005
Location: Virginia

Junior Member

Hi all, any assistance will be gratly appreciated. I am working off an Oracle form. On that form I have a push button that deletes the record displayed on the screen. Behind the button I have PL SQL that is basic delete table where dept = :dept and account = :account. However I keep getting a deadlock error when I execute the code. I tried to pass the dept values through assigned varialbles, but I am getting the same error. Any Ideas?

Thanks
George Trecarten
gtrecart@hotmail.com

Report message to a moderator

Re: Please Help [message #148866 is a reply to message #148842]

Mon, 28 November 2005 15:40

joy_division
Messages: 4963
Registered: February 2005
Location: East Coast USA

Senior Member

Forms is the proper forum for these questions...

But, you cannot delete the current record with a delete DML statement in a trigger. You have to use something like DELETE_RECORD (if I recall my forms commands).

Either make a NULL block with the values so you can use a DELETE DML statement, or use the DELETE_RECORD command. I'd go with the NJULL block, since you are deleting more than one row and the other way will cause off kinds of problems trying to find the rows that aren't the current row.

Report message to a moderator

Re: Please Help [message #150038 is a reply to message #148842]

Tue, 06 December 2005 01:28

djmartin
Messages: 10181
Registered: March 2005
Location: Surges Bay TAS Australia

Senior Member
Account Moderator

Have you solved your problem?

David

Report message to a moderator

Previous Topic:	Clear Cursor Block
Next Topic:	update

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri Sep 20 04:27:43 CDT 2024