General information
Category:
The Mere Mortals .NET Framework
>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
Previous
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only