>Could you please help me with this issue?
>
>I have a problem while inserting a new record in oracle database, but it works fine while inserting the same in SQL database.
>
>I have used business layer generator wizard to create Business objects, Entities, Dataaccess and Rules classes for the table named Client_Master
>
>But while trying to insert a record
>
>When I call
>
>ClientMasterEntity ODEntity = clientMaster.NewEntity();
>
>Which in turn calls the method CreateSelectCommand()
>
>public override System.Data.IDbCommand CreateSelectCommand()
>
> {
>
> System.Data.OracleClient.OracleCommand SelectCommand = (System.Data.OracleClient.OracleCommand)this.CreateCommand("WORLDKING.MMNET_CLIENT_MASTER_GEN.CLIENT_MASTERSelect");
>
> SelectCommand.CommandType = System.Data.CommandType.StoredProcedure;
>
> SelectCommand.Parameters.AddRange(new System.Data.OracleClient.OracleParameter[] {
>
>new System.Data.OracleClient.OracleParameter("P_RC", System.Data.OracleClient.OracleType.Cursor, 0, System.Data.ParameterDirection.Output, true, ((byte)(0)), ((byte)(0)), "", System.Data.DataRowVersion.Current, null)});
>
> return SelectCommand;
>
> }
>
>And then calls CreateDataAdapter()
>
>public override System.Data.IDataAdapter CreateDataAdapter()
>
> {
>
> return this.DataAdapter;
>
> }
>
>Which raises an exception
>
>
>
>ORA-06550: line 1, column 7:
>
>PLS-00306: wrong number or types of arguments in call to 'CLIENT_MASTERSELECT'
>
>ORA-06550: line 1, column 7:
>
>PL/SQL: Statement ignored
>
>
>
>The business layer generator created the SQL as follows for CLIENT_MASTERSelect Procedure
>
>PROCEDURE CLIENT_MASTERSelect
>
>(
>
> P_RC OUT SYS_REFCURSOR
>
>)
>
>IS
>
>BEGIN
>
> OPEN P_RC FOR
>
> SELECT *
> FROM CLIENT_MASTER
>
> ;
>
>END CLIENT_MASTERSelect;
>
>
>
>Please let me know, if I am missing something here?
>
>
>
>Thanks & Kind Regards,
>
>Vidya
------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
>Vidya, did you try to execute the CLIENT_MASTERSelect procedure outside of MM and outside of VS?
>
>I would verify the stored procedure works and doesn't have an issue.
>
> If this turns out to be narrowed down to within MM you should re-post in the Mere Mortals section of the forum.
>
>Tim
>T. Grant Bryan
>BT Systems
------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
>Thanks Tim,
>
>I executed the procedure in PL/SQL Toad and in a small VS project and works fine and returns client_master data from the client_master table.
>
>So as you mentioned i would like to re-post it in MM framework section, but i don't know how to get to Mere Mortals section of the forum.
>
>Could you please let me know the navigation path.
>
>I can only find 2 forum sections .NET and Universal Thread. So do i have to post it in Universal Thread Section?
>
>Kind Regards,
>Vidya

------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
>Sorry Vidya, it is actually a "Category" in the .NET Section. When you choose new message with .Net forum then you pick the category.
>
>The category list includes a category for Mere Mortals Framework. The reason I suggested this is because there may be some members
>
>who monitor that section but maybe not all of the others.
>
>Tim
>T. Grant Bryan
>BT Systems
------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
>I responded to your message in the other category before I realized you found this area OK.
>Is it possible that you could post the full Stack Trace of the error?

>Tim
>T. Grant Bryan
>BT Systems

------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
Thanks Tim,

I will do that.

Vidya