OraFAQ Forum: Forms » ORA-04062 - Unable to save transaction in Detail block

Home » Developer & Programmer » Forms » ORA-04062 - Unable to save transaction in Detail block

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

ORA-04062 - Unable to save transaction in Detail block [message #270160]

Wed, 26 September 2007 00:17

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.

Report message to a moderator

Re: ORA-04062 - Unable to save transaction in Detail block [message #270163 is a reply to message #270160]

Wed, 26 September 2007 00:23

BlackSwan
Messages: 26766
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?

Report message to a moderator

Re: ORA-04062 - Unable to save transaction in Detail block [message #270166 is a reply to message #270163]

Wed, 26 September 2007 00:37

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.

Report message to a moderator

Re: ORA-04062 - Unable to save transaction in Detail block [message #270178 is a reply to message #270166]

Wed, 26 September 2007 01:11

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

Senior Member
Account Moderator

Are you modifying a form that is part of an existing system or writing something from scratch?

David

Report message to a moderator

Re: ORA-04062 - Unable to save transaction in Detail block [message #270183 is a reply to message #270178]

Wed, 26 September 2007 01:21

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....??

Report message to a moderator

Re: ORA-04062 - Unable to save transaction in Detail block [message #270191 is a reply to message #270183]

Wed, 26 September 2007 01:32

djmartin
Messages: 10181
Registered: March 2005
Location: Surges Bay TAS 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

Report message to a moderator

Re: ORA-04062 - Unable to save transaction in Detail block [message #270194 is a reply to message #270191]

Wed, 26 September 2007 01:39

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.

Report message to a moderator

Re: ORA-04062 - Unable to save transaction in Detail block [message #270200 is a reply to message #270194]

Wed, 26 September 2007 02:11

djmartin
Messages: 10181
Registered: March 2005
Location: Surges Bay TAS 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

Report message to a moderator

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

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Mon Mar 10 14:17:09 CDT 2025