Databases
StackOverflow2013
Postsdbo
POProcedure expects parameter even though the parameter is provided
 

Note that there are some explanatory texts on larger screens.

plurals
  1. POProcedure expects parameter even though the parameter is provided
    primarykey
    data
    text
    <p>I saw that some others faced this similar problem. I have read and checked the question titled <a href="https://stackoverflow.com/questions/368642/procedure-expects-parameter-which-was-not-supplied">Procedure expects parameter which was not supplied</a>. I thought it would solve my problem but I was wrong :( I did check the steps that were advised there with no luck. Here is my code:</p> <pre><code>oOleDbCommand.CommandText = "usp_PettyCash_AddBillInfo"; oOleDbCommand.Parameters.Add("@BillID", OleDbType.BigInt).Value = nBillID; oOleDbCommand.Parameters.Add("@SerialNo", OleDbType.VarChar).Value = sSerialNo; oOleDbCommand.Parameters.Add("@UniqueID", OleDbType.VarChar).Value = oInputBill[0].UniqueID.ToString(); oOleDbCommand.Parameters.Add("@BilledWeekDate", OleDbType.Date).Value = oInputBill[0].BilledWeekDate; oOleDbCommand.Parameters.Add("@BilledWeekNo", OleDbType.VarChar).Value = oInputBill[0].BilledWeekNo.ToString(); oOleDbCommand.Parameters.Add("@SettledWeekDate", OleDbType.Date).Value = oInputBill[0].SettledWeekDate; oOleDbCommand.Parameters.Add("@SettledWeekNo", OleDbType.VarChar).Value = oInputBill[0].SettledWeekNo; oOleDbCommand.Parameters.Add("@BillStatus", OleDbType.VarChar).Value = oInputBill[0].BillStatus.ToString(); oOleDbCommand.Parameters.Add("@UpdatedBy", OleDbType.VarChar).Value = oInputBill[0].UpdatedBy; oOleDbCommand.Parameters.Add("@UpdateDate", OleDbType.Date).Value = oInputBill[0].UpdateDate; </code></pre> <p>Stored Procedure is:</p> <pre><code>CREATE PROCEDURE usp_PettyCash_AddBillInfo ( @BillID bigint, @SerialNo varchar(50), @UniqueID varchar(50), @BilledWeekDate datetime, @BilledWeekNo varchar(50), @SettledWeekDate datetime, @SettledWeekNo varchar(50), @BillStatus varchar(50), @UpdatedBy varchar(50), @UpdateDate datetime ) AS BEGIN INSERT INTO t_BillInfo (BillID, SerialNo, UniqueID, BilledWeekDate, BilledWeekNo, SettledWeekDate, SettledWeekNo, BillStatus, UpdatedBy, UpdateDate) VALUES (@BillID, @SerialNo, @UniqueID, @BilledWeekDate, @BilledWeekNo, @SettledWeekDate, @SettledWeekNo, @BillStatus, @UpdatedBy, @UpdateDate) END GO </code></pre> <p>While debugging, i found the value of <code>nBillID = 1.0</code> and <code>sSerialNo='B201200001'</code>. But when trying to execute the <code>ExecuteNonQuery</code> command, it gives the exception:</p> <blockquote> <p>"Procedure 'usp_PettyCash_AddBillInfo' expects parameter '@BillID', which was not supplied."</p> </blockquote> <p>I can't find any workarounds. Please help. Sorry for re-asking the question.</p> <p>As a workaround, I used this:</p> <pre><code>oOleDbCommand.CommandText = "INSERT INTO t_BillInfo (BillID, SerialNo, UniqueID, BilledWeekDate, BilledWeekNo, SettledWeekDate, SettledWeekNo, BillStatus, UpdatedBy, UpdateDate)"+ " VALUES (" + nBillID + ", '" + sSerialNo + "', '" + oInputBill[0].UniqueID.ToString() + "','" + oInputBill[0].BilledWeekDate.ToShortDateString() + "', '" + oInputBill[0].BilledWeekNo + "', '" + oInputBill[0].SettledWeekDate.ToShortDateString() + "', '" + oInputBill[0].SettledWeekNo + "', '" + oInputBill[0].BillStatus.ToString() + "', '" + oInputBill[0].UpdatedBy + "', '" + oInputBill[0].UpdateDate.ToShortDateString() + "')"; </code></pre> <p>Although I did not like this type of coding, but this works.</p>
    singulars
    1. PO
      singulars
      1. PTAnswer
    1. This table or related slice is empty.
    1. PTQuestion
    1. USCommunity
    1. USV. P. Verma
    plurals
    1. PL
      singulars
      1. LTLinked
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. PO
      singulars
      1. PTAnswer
    1. VO
      singulars
      1. POProcedure expects parameter even though the parameter is provided
      1. This table or related slice is empty.
      1. VTUpMod
    2. VO
      singulars
      1. POProcedure expects parameter even though the parameter is provided
      1. This table or related slice is empty.
      1. VTUpMod
    3. VO
      singulars
      1. POProcedure expects parameter even though the parameter is provided
      1. USV. P. Verma
      1. VTFavorite
    1. COWell one thing that jumps to my eye: you're defining parameters as type `OleDbType.VarChar` - but you're not defining any **length!** That means those parameters will be **1 character long** - probably **not** what you wanted ..... you need to **specify the desired length** like this: `oOleDbCommand.Parameters.Add("@SerialNo", OleDbType.VarChar, 50).Value = .....`
      singulars
      1. POProcedure expects parameter even though the parameter is provided
      1. USmarc_s
    2. COSo I assume you've already tried to add `oOleDbCommand.CommandType = CommandType.StoredProcedure;`, correct?
      singulars
      1. POProcedure expects parameter even though the parameter is provided
      1. USEnrico Campidoglio
    3. CO@ Enrico, Yes. @ marc_s, i tried that too, but no change :(
      singulars
      1. POProcedure expects parameter even though the parameter is provided
      1. USV. P. Verma
 

Querying!

 
Guidance
A row detail

Detail views are divided into sections. All the information in the data section comes from columns in the selected row. The other sections display data from other, related rows.

Related data can be related in a to-one or a to-many fashion. Captions of data related in a to-many fashion link to a list view showing a filtered view of the table.

Try moving around until you find a non-empty to-many entry and click on the label to get to one. You can move back to the root by clicking on the database name in the header.

SQuiL has stopped working due to an internal error.

If you are curious you may find further information in the browser console, which is accessible through the devtools (F12).

Reload