problem in executing stored procedure

[souravghosh18]

I am executing a stored procedure written in oracle from my web page.The procedure has 5 input variable and 2 output variable.But when i am executing the procedure it gives an error. "ORA-06502: PL/SQL: numeric or value error: character string buffer too small" i ma using following code, cmdproc.CommandType = CommandType.StoredProcedure cmdproc.CommandText = "avlmfg.PROC_TUBE_COIL_LINK" Dim tub_batch As OracleParameter = cmdproc.Parameters.Add("ls_tube_batch", OracleDbType.Varchar2) Dim tub_aufnr As OracleParameter = cmdproc.Parameters.Add("ls_aufnr", OracleDbType.Varchar2) Dim tub_matnr As OracleParameter = cmdproc.Parameters.Add("ls_mill_matnr", OracleDbType.Varchar2) Dim tub_nos As OracleParameter = cmdproc.Parameters.Add("ln_no_of_tubes", OracleDbType.Int64) Dim tub_arbpl As OracleParameter = cmdproc.Parameters.Add("ls_arbpl", OracleDbType.Varchar2) Dim tub_error_flag As OracleParameter = cmdproc.Parameters.Add("LS_ERROR_FLAG", OracleDbType.Varchar2) Dim tub_data1 As OracleParameter = cmdproc.Parameters.Add("data1", OracleDbType.Varchar2) tub_batch.Direction = ParameterDirection.Input tub_aufnr.Direction = ParameterDirection.Input tub_matnr.Direction = ParameterDirection.Input tub_nos.Direction = ParameterDirection.Input tub_arbpl.Direction = ParameterDirection.Input tub_error_flag.Direction = ParameterDirection.Output tub_data1.Direction = ParameterDirection.Output tub_batch.Value = txtChargR1.Text.ToUpper() tub_aufnr.Value = txtPO.Text.Trim tub_matnr.Value = txtMatnr1.Text.Trim tub_nos.Value = schqty tub_arbpl.Value = arbpl cmdproc.ExecuteNonQuery() Thanx in advance,

[Lost User]

souravghosh18 wrote:

Dim tub_batch As OracleParameter = cmdproc.Parameters.Add("ls_tube_batch", OracleDbType.Varchar2)

Try adding the length of the varcher2 variable as OracleParameter = cmdproc.Parameters.Add("ls_tube_batch", OracleDbType.Varchar2, 100) 100 will be the lenght of varchar you have defined in database

Regards Aman Bhullar www.arlivesupport.com[^]

[Niladri_Biswas]

In some fields the parameter length mismatch is happening :)

Niladri Biswas