Home » SQL & PL/SQL » SQL & PL/SQL » ORA-8177 when execute procedure from forms10g (Linux 6.4, oracle 11.2.0.3 , patch 14666138 , forms 10g)
ORA-8177 when execute procedure from forms10g [message #614671] Sun, 25 May 2014 12:12 Go to next message
RAY_HT
Messages: 155
Registered: May 2005
Location: Giza
Senior Member
Dear ,

i'm facing a error 8177 when executing pl/sql procedure from oracle forms10g while the same procedure executes fine from sqlplus

i searched for this bug and i found the Patch 14666138 on metalink and it should fix this bug but after patching database , same error raises.

also i executed "alter session set isolation_level=serializable
but still error raises !!

i run my code on oracle 11.2.0.3 RAC on Oracle Linux 6.4 and from Oracle forms 10g

any help???

Report message to a moderator

Re: ORA-8177 when execute procedure from forms10g [message #614673 is a reply to message #614671] Sun, 25 May 2014 12:19 Go to previous messageGo to next message
BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal
Senior Member
>any help???
not from me, since I can't debug code I can not see.

08177, 00000, "can't serialize access for this transaction"
// *Cause:   Encountered data changed by an operation that occurred after
//           the start of this serializable transaction.
// *Action:  In read/write transactions, retry the intended operation or
//           transaction.


Please read and follow the forum guidelines, to enable us to help you:

http://www.orafaq.com/forum/t/88153/0/ and please read http://www.orafaq.com/forum/t/174502/102589/

Report message to a moderator

Re: ORA-8177 when execute procedure from forms10g [message #614674 is a reply to message #614671] Sun, 25 May 2014 12:34 Go to previous messageGo to next message
Michel Cadot
Messages: 68645
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator

Follow advice given at http://www.orafaq.com/forum/mv/msg/191478/614651/#msg_614651.

Report message to a moderator

Re: ORA-8177 when execute procedure from forms10g [message #614677 is a reply to message #614674] Sun, 25 May 2014 12:47 Go to previous messageGo to next message
RAY_HT
Messages: 155
Registered: May 2005
Location: Giza
Senior Member
if you read what i wrote you will know that i did what you advised ( Patches and alter session )

if anyone else can help and propose a good solution ??!!

Report message to a moderator

Re: ORA-8177 when execute procedure from forms10g [message #614680 is a reply to message #614677] Sun, 25 May 2014 13:14 Go to previous messageGo to next message
Michel Cadot
Messages: 68645
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator

I'm waiting for you to feedback to your previous topics.
Why should we help someone that didn't even say if what we posted helped or not and what was the solution of his previous problems?
Please answer!

Report message to a moderator

Re: ORA-8177 when execute procedure from forms10g [message #614762 is a reply to message #614671] Mon, 26 May 2014 17:53 Go to previous messageGo to next message
RAY_HT
Messages: 155
Registered: May 2005
Location: Giza
Senior Member
Simply because nothing happen , still same error raises

Report message to a moderator

Re: ORA-8177 when execute procedure from forms10g [message #614765 is a reply to message #614671] Tue, 27 May 2014 00:09 Go to previous message
Littlefoot
Messages: 21808
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
RAY_HT wrote on Sun, 25 May 2014 19:12

i'm facing a error 8177 when executing pl/sql procedure from oracle forms10g while the same procedure executes fine from sqlplus


What does the bold text mean? Did you
  • copy/paste procedure code into your form (so it now resides under the "Program Units" node of the Object Navigator window), or
  • call a stored procedure from your form (so it still resides in the database)

If you use the first option, try to switch to the second and see how it behaves.

Report message to a moderator

Previous Topic: SQL or PL/SQL query to sum and avg time stamps
Next Topic: no output shown
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Thu Apr 25 09:05:26 CDT 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.