hi to all,

I want to insert data into db.but when i click on button i get folllowing error

Line 121: mycmd2.Parameters(":f_year").Value = f.Value
Line 122:
Line 123: mycmd2.ExecuteNonQuery()
Line 124:
Line 125:


Source File: C:\Inetpub\wwwroot\dhrov\add_new_customer.aspx.vb Line: 123

Stack Trace:


[OracleException (0x80131938): ORA-01008: not all variables bound
]
   System.Data.OracleClient.OracleConnection.CheckErr or(OciErrorHandle errorHandle, Int32 rc) +204
   System.Data.OracleClient.OracleCommand.Execute(Oci StatementHandle statementHandle, CommandBehavior behavior, Boolean needRowid, OciRowidDescriptor& rowidDescriptor, ArrayList& resultParameterOrdinals) +1024
   System.Data.OracleClient.OracleCommand.ExecuteNonQ ueryInternal(Boolean needRowid, OciRowidDescriptor& rowidDescriptor) +447
   System.Data.OracleClient.OracleCommand.ExecuteNonQ uery() +108
   add_new_customer.save_Click(Object sender, EventArgs e) in C:\Inetpub\wwwroot\dhrov\add_new_customer.aspx.vb: 123
   System.Web.UI.WebControls.Button.OnClick(EventArgs e) +105
   System.Web.UI.WebControls.Button.RaisePostBackEven t(String eventArgument) +107
   System.Web.UI.WebControls.Button.System.Web.UI.IPo stBackEventHandler.RaisePostBackEvent(String eventArgument) +7
   System.Web.UI.Page.RaisePostBackEvent(IPostBackEve ntHandler sourceControl, String eventArgument) +11
   System.Web.UI.Page.RaisePostBackEvent(NameValueCol lection postData) +33
   System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint) +5102

Here is my code
 str3 = "user id= nfc; password=nfc; data source = dh"
        mycon2 = New OracleConnection(str3)
        mycon2.Open()

        Dim mycmd2 As New OracleCommand

        mycmd2.CommandText = "INSERT INTO sub_ledger_master" _
       & "(SL_COMPANY_CODE,SL_FINANCIAL_YEAR_CODE,SL_BRANCH _CODE," _
       & "SL_GL_ACCOUNT_CODE,SL_ACCOUNT_CODE,SL_DESCRIPTION ,SL_UPDATION_DATE,WHERENAME)" _
       & "values('DD',:f_year,'L020','1081',:c_code,:c_name ,TO_DATE(:d_date,'DD/MM/YYYY'),:wh)"

        mycmd2.Connection = mycon2

        mycmd2.Parameters.Add(New OracleParameter(":c_code", OracleType.VarChar, 9, "SL_ACCOUNT_CODE"))
        mycmd2.Parameters(":c_code").Value = ccode.Text

        mycmd2.Parameters.Add(New OracleParameter(":c_name", OracleType.VarChar, 150, "SL_DESCRIPTION"))
        mycmd2.Parameters(":c_name").Value = cname.Text

        mycmd2.Parameters.Add(New OracleParameter(":d_date", OracleType.VarChar, 20))
        mycmd2.Parameters(":d_date").Value = txtfrom.Text

        mycmd2.Parameters.Add(New OracleParameter(":f_year", OracleType.VarChar, 8))
        mycmd2.Parameters(":f_year").Value = f.Value

        mycmd2.ExecuteNonQuery()

Please tell me whats problem with my code.

Thanks in advance.

hi there..

is :wh a parameter??? you are not sending any value to it....

HTH

Gonzalo

================================================== =========
Read this if you want to know how to get a correct reply for your question:
http://www.catb.org/~esr/faqs/smart-questions.html
^^Took that from dparsons signature and he Took that from planoie's profile
================================================== =========
My programs achieved a new certification (can you say the same?):
WORKS ON MY MACHINE
http://www.codinghorror.com/blog/archives/000818.html
================================================== =========
I know that CVS was evil, and now i got the proof:
http://worsethanfailure.com/Articles...-Hate-You.aspx
================================================== =========

thanks Gonzalo

i had solved this problem.

How did you solve it? People are reading your request and spending time on answering you. The least you could do is post your solution.

here is solution :


            mycmd2.CommandText = "INSERT INTO SUB_LEDGER_MASTER(SL_COMPANY_CODE,SL_FINANCIAL_YEA R_CODE," _
            & "SL_BRANCH_CODE,SL_GL_ACCOUNT_CODE,SL_ACCOUNT_CODE ,SL_DESCRIPTION,SL_UPDATION_DATE,WHERENAME)" _
           & "values('DD',:SL_FINANCIAL_YEAR_CODE,'L020','1081' ,:SL_ACCOUNT_CODE,:SL_DESCRIPTION,to_date(:SL_UPDA TION_DATE,'dd/mm/yyyy'),:wh)"

            mycmd2.Connection = mycon2

            mycmd2.Parameters.Add(New OracleParameter(":SL_ACCOUNT_CODE", OracleType.VarChar, 9))
            mycmd2.Parameters(":SL_ACCOUNT_CODE").Value = ccode.Text



            mycmd2.Parameters.Add(New OracleParameter(":SL_DESCRIPTION", OracleType.VarChar, 150))
            mycmd2.Parameters(":SL_DESCRIPTION").Value = cname.Text

            mycmd2.Parameters.Add(New OracleParameter(":SL_UPDATION_DATE", OracleType.VarChar, 20))
            mycmd2.Parameters(":SL_UPDATION_DATE").Value = txtfrom.Text

            mycmd2.Parameters.Add(New OracleParameter(":SL_FINANCIAL_YEAR_CODE", OracleType.VarChar, 8))
            mycmd2.Parameters(":SL_FINANCIAL_YEAR_CODE").Value = f.Value

            mycmd2.Parameters.Add(New OracleParameter(":wh", OracleType.VarChar, 60))
            mycmd2.Parameters(":wh").Value = wh

            mycmd2.ExecuteNonQuery()