Home » Developer & Programmer » Forms » ORA-04062 - Unable to save transaction in Detail block
ORA-04062 - Unable to save transaction in Detail block [message #270160] Wed, 26 September 2007 00:17 Go to next message
rajatchhabra
Messages: 7
Registered: September 2007
Location: India
Junior Member

In oracle forms while saving data in one detail block I am getting unhandeled exception. Actually source file is not avialable with me, And I tried with three or four versions of FMX. Not able to save transaction. Plz help.

Oracle Help says

cause : An attempt was made to execute a stored procedure to service a remote procedure call stub that specifies a timestamp or signature that is different from the current timestamp or signature of the procedure.

Action : Recompile the caller to obtain the new timestamp.
Re: ORA-04062 - Unable to save transaction in Detail block [message #270163 is a reply to message #270160] Wed, 26 September 2007 00:23 Go to previous messageGo to next message
BlackSwan
Messages: 25050
Registered: January 2009
Location: SoCal
Senior Member
Let us review what we know for sure.
You have a problem.
Let us review what we ( the readers) don't know.
Operating system name & version.
Oracle version to 4 decimal places.
Version of Oracle Forms involved.

What happens if the form is invoked a 2nd time?
Re: ORA-04062 - Unable to save transaction in Detail block [message #270166 is a reply to message #270163] Wed, 26 September 2007 00:37 Go to previous messageGo to next message
rajatchhabra
Messages: 7
Registered: September 2007
Location: India
Junior Member



Requested version information is as below.

Windows XP professional Version 2002 Service Pack 2

Forms [32 Bit] Version 6.0.8.25.2 (Production)

Oracle Database 10g Enterprise Edition Release 10.2.0.1.0

I am getting same error every time I open and Actually its a Sales Order form which is available with multiple versions(compiled at different dates). I checked in different FMX of different timestamps But still getting error while saving Detail record. Header record gets saved.
Re: ORA-04062 - Unable to save transaction in Detail block [message #270178 is a reply to message #270166] Wed, 26 September 2007 01:11 Go to previous messageGo to next message
djmartin
Messages: 10180
Registered: March 2005
Location: Canberra ACT Australia
Senior Member
Account Moderator
Are you modifying a form that is part of an existing system or writing something from scratch?

David
Re: ORA-04062 - Unable to save transaction in Detail block [message #270183 is a reply to message #270178] Wed, 26 September 2007 01:21 Go to previous messageGo to next message
rajatchhabra
Messages: 7
Registered: September 2007
Location: India
Junior Member

Actually we have an ERP system and there while Saving the record in detail block of Sales Order screen I am getting this error.


I am working on existing FMX as I can not change the Form or recompile it.

As per information i retrieved its coming because of Some Database procedure which is being called in form has got changed either in parameter positioning or in some other way and now its design is not matching with DB proc getting called in Form.

If i recompile the source and generate FMX then it will be resolved which is not supposed to do as per our process.

Any other way to handle this other than recompiling the form....??
Re: ORA-04062 - Unable to save transaction in Detail block [message #270191 is a reply to message #270183] Wed, 26 September 2007 01:32 Go to previous messageGo to next message
djmartin
Messages: 10180
Registered: March 2005
Location: Canberra ACT Australia
Senior Member
Account Moderator
Okay, so you are not going to change the logic of the form. Therefore, I assume that you (or someone else in your facility) have changed the database procedure parameter list. I suggest that you restore the procedure to the old parameter list and then create another copy of procedure with the same name but with the extra parameters. This is called 'overloading'.

David
Re: ORA-04062 - Unable to save transaction in Detail block [message #270194 is a reply to message #270191] Wed, 26 September 2007 01:39 Go to previous messageGo to next message
rajatchhabra
Messages: 7
Registered: September 2007
Location: India
Junior Member

Dear David,

that is an possibility that DB proc parameter list is changed or it might be some other change also..

Also i am not sure in which procedure this thing has got changed. As we are using PLL's and DB procs are called in Local program units and Pll's also.

Its not so easy to find which PLL or Local program unit in form is calling which DB proc which has got changed. Overloading can be done but in which procedure ?? how to find ??

Only solution i could sense is to recompile the form which I am avoiding and trying to do some other way if possible.
Re: ORA-04062 - Unable to save transaction in Detail block [message #270200 is a reply to message #270194] Wed, 26 September 2007 02:11 Go to previous message
djmartin
Messages: 10180
Registered: March 2005
Location: Canberra ACT Australia
Senior Member
Account Moderator
I normally find which procedure has changed by wacking the DBA about the head and asking him what he has changed without telling me.

Do you have any source control facility? If so, look in there.

If a procedure was changed and put into production then I can only assume that your production application has stopped working. Wack them around the head again and tell them that changing code and not testing it before going into production is going to get the lot of them fired. Get them to restore the application from backup and move forward from there.

David
Previous Topic: Barcode Printers
Next Topic: Change title of a separate window
Goto Forum:
  


Current Time: Sat Dec 10 09:01:32 CST 2016

Total time taken to generate the page: 0.08797 seconds