Vidya,

Ahh, this makes sense because the original error you showed was an Oracle error. After you tested it directly in Oracle, it had to be somewhere between the call in the form and the actual call to the Oracle SP. It looks like a change may be included in the Oracle DataAccessClass in the next build. Glad it is solved,
Good Luck
Tim

>--Is this a Windows forms application?
>Yes, it is windows form application
>
>--Are you making these calls inside a form?
>I am making call from the windows form as well as unit testing it in a sepearte NUnit project.
>
>--Is the ClientMasterEntity the only Entity object you created for the ClientMaster business object?
>Yes, clientMasterEntity is the only entity created for this ClientMaster business object
>
>--If these are all true, what is triggering the creation of a new entity? Is this from a button?
>In the windows form application, yes it is a form button
>In the NUnit project, i have just defined this as a Test method
>
>Thanks for your solution,and thanks for your help i really appreciate it, it works once i make change the base class for the ClientMaster
>DataAccess as per Kevin McNeish suggestion
>
>--Vidya,
>
>--I don’t know if this is an issue with the case of your stored procedure names, but try this:
>
>--1. Create an ADataAccessOracle class (subclassed from mmDataAccessOracle) in your project.
>--
>
>--2. Add the following method override to the class:
>-- public override DataTable GetStoredProcedureParameters(string schema, string storedProcedure)
>--
>-- {
>
>-- //UCase the stored procedure name
>--
>-- storedProcedure = storedProcedure.ToUpper();
>
>-- return base.GetStoredProcedureParameters(schema, storedProcedure);
>
>-- }
>
>--3. If you are using custom data access classes, change your custom data access class so it is a subclass of this new
>-- ADataAccessOracle class. If you are not using custom data access classes, change your project’s Factory class CreateDataAccessOracle() --- method so it returns and instance of ADataAccessOracle. For example:
>
>-- return new ADataAccessOracle();
>
>-- Best Regards,
>
>
>-- Kevin McNeish
>
>-- Microsoft .NET MVP
>
>-- INETA Speaker
>
>-- President, Oak Leaf Enterprises, Inc.
>
>-- Web: http://www.oakleafsd.com
>
>-- Blog: http://www.msmvps.com/KevinMcNeish
>
>
>
>-- this.NewRow();
>-- or if you are calling this on a business object other than the primary business object you can call the overload
>-- this.NewRow(ClientMaster);
>-- After all the edits, etc are complete you can just call the forms save
>
>-- mmSaveDataResult result = this.Save();
>-- or for business objects other than the primary you can call the overload
>-- mmSaveDataResult result = this.Save(ClientMaster);
>
>
>-- Can you fill me in a bit on what you are trying to do, maybe we can simplify the process a bit.
>-- By the way, are you using an evaluation version of MM?
>
>
>I am trying to create a new record for Client_Master and save the data back to the database.
>
>No i am not using an Evaluation version of MM, we actually purchase 2 copies last year
>
>
>Thanks & Kind Regards
>Vidya