Error 06550 oracle.

System.Data.OracleClient.OracleException was caught
  Message="ORA-06550: line 1, column 7:\nPLS-00201: identifier 'INSERT_PRICE_LIST_HDR' must be declared\nORA-06550: line 1, column 7:\nPL/SQL: Statement ignored\n"
  Source="System.Data.OracleClient"
  ErrorCode=-2146232008
  Code=6550
  StackTrace:
       at System.Data.OracleClient.OracleConnection.CheckError(OciErrorHandle errorHandle, Int32 rc)
       at System.Data.OracleClient.OracleCommand.Execute(OciStatementHandle statementHandle, CommandBehavior behavior, Boolean needRowid, OciRowidDescriptor& rowidDescriptor, ArrayList& resultParameterOrdinals)
       at System.Data.OracleClient.OracleCommand.ExecuteNonQueryInternal(Boolean needRowid, OciRowidDescriptor& rowidDescriptor)
       at System.Data.OracleClient.OracleCommand.ExecuteNonQuery()
       at Microsoft.Practices.EnterpriseLibrary.Data.Database.DoExecuteNonQuery(DbCommand command)
       at Microsoft.Practices.EnterpriseLibrary.Data.Database.ExecuteNonQuery(DbCommand command)
       at Cwb.InitialPriceReporting.Form1.Mode0_SaveInsertPriceListHeader() in C:\SvnWork\InitialPriceReporting\DotNet\InitialPriceReporting\Form1.cs:line 183


                    Database db = DatabaseFactory.CreateDatabase("InitialPrices.Properties.Settings.ConnectionString");


                    // Create the DbCommand object
                    DbCommand dbCommand = db.GetStoredProcCommand("insert_price_list_hdr");
                    dbCommand.CommandTimeout = 180;
                   
                    db.AddInParameter(dbCommand, "p_price_list_hdr_id", DbType.String, txtCropYear.Text + txtListNo.Text);
                    db.AddInParameter(dbCommand, "p_wht_tough_disc_amt", DbType.Decimal, 0.0);
                    db.AddInParameter(dbCommand, "p_wht_damp_disc_amt", DbType.Decimal, 0.0);
                    db.AddInParameter(dbCommand, "p_wht_stone_disc_amt", DbType.Decimal, 0.0);

                    db.AddInParameter(dbCommand, "p_durum_tough_disc_amt", DbType.Decimal, 0.0);
                    db.AddInParameter(dbCommand, "p_durum_damp_disc_amt", DbType.Decimal, 0.0);
                    db.AddInParameter(dbCommand, "p_durum_stone_disc_amt", DbType.Decimal, 0.0);

                    db.AddInParameter(dbCommand, "p_bly_tough_disc_amt", DbType.Decimal, 0.0);
                    db.AddInParameter(dbCommand, "p_bly_damp_disc_amt", DbType.Decimal, 0.0);
                    db.AddInParameter(dbCommand, "p_bly_stone_disc_amt", DbType.Decimal, 0.0);

                    db.AddInParameter(dbCommand, "p_desigtd_bly_tough_disc_amt", DbType.Decimal, 0.0);
                    db.AddInParameter(dbCommand, "p_desigtd_bly_damp_disc_amt", DbType.Decimal, 0.0);

                    db.AddInParameter(dbCommand, "p_price_list_status_type_name", DbType.String, "0");
                    db.AddInParameter(dbCommand, "p_load_dtm", DbType.DateTime, System.DateTime.Now);
                    db.AddInParameter(dbCommand, "p_user_name", DbType.String, "Mathieu");


                    db.AddInParameter(dbCommand, "p_wht_indr_flag", DbType.String, "1");
                    db.AddInParameter(dbCommand, "p_durum_indr_flag", DbType.String, "1");
                    db.AddInParameter(dbCommand, "p_bly_indr_flag", DbType.String, "1");
                    db.AddInParameter(dbCommand, "p_desigtd_bly_indr_flag", DbType.String, "1");

                    db.AddInParameter(dbCommand, "p_load_type_name", DbType.String, "Adjustment");

                    db.AddInParameter(dbCommand, "p_wht_basis_num", DbType.Int32, 1);
                    db.AddInParameter(dbCommand, "p_durum_basis_num", DbType.Int32, 1);
                    db.AddInParameter(dbCommand, "p_bly_basis_num", DbType.Int32, 1);
                    db.AddInParameter(dbCommand, "p_desigtd_bly_basis_num", DbType.Int32, 1);



                    db.AddInParameter(dbCommand, "p_src_file_path_desc", DbType.String, "C:");
                   
                    db.AddInParameter(dbCommand, "p_pool_part_code", DbType.String, "1");

                    db.AddInParameter(dbCommand, "p_sct_price_list_name", DbType.String, "1");
                    db.AddInParameter(dbCommand, "p_sct_effectv_dtm", DbType.DateTime, System.DateTime.Now);
                   
                    db.AddInParameter(dbCommand, "p_row_cnt_qty", DbType.Decimal, 1.0);
                    db.AddInParameter(dbCommand, "p_price_sum_amt", DbType.Decimal, 0.0);
                    db.ExecuteNonQuery(dbCommand);
                   
mathieu_cuprykAsked:
Who is Participating?

Improve company productivity with a Business Account.Sign Up

x
Advertise Here
 
sdstuberConnect With a Mentor Commented:
from your previous question on this topic...

your procedure isn't a standalone procedure,  it's a member of a package so you must specify the package

change this...

          DbCommand dbCommand = db.GetStoredProcCommand("insert_price_list_hdr");

to

          DbCommand dbCommand = db.GetStoredProcCommand("PRICE_LIST_REPORTING.insert_price_list_hdr");
0
 
mathieu_cuprykAuthor Commented:
{System.Data.OracleClient.OracleException: ORA-06550: line 1, column 7:
PLS-00306: wrong number or types of arguments in call to 'INSERT_PRICE_LIST_HDR'
ORA-06550: line 1, column 7:
PL/SQL: Statement ignored

   at System.Data.OracleClient.OracleConnection.CheckError(OciErrorHandle errorHandle, Int32 rc)
   at System.Data.OracleClient.OracleCommand.Execute(OciStatementHandle statementHandle, CommandBehavior behavior, Boolean needRowid, OciRowidDescriptor& rowidDescriptor, ArrayList& resultParameterOrdinals)
   at System.Data.OracleClient.OracleCommand.ExecuteNonQueryInternal(Boolean needRowid, OciRowidDescriptor& rowidDescriptor)
   at System.Data.OracleClient.OracleCommand.ExecuteNonQuery()
   at Microsoft.Practices.EnterpriseLibrary.Data.Database.DoExecuteNonQuery(DbCommand command)
   at Microsoft.Practices.EnterpriseLibrary.Data.Database.ExecuteNonQuery(DbCommand command)
   at Cwb.InitialPriceReporting.Form1.Mode0_SaveInsertPriceListHeader() in C:\SvnWork\InitialPriceReporting\DotNet\InitialPriceReporting\Form1.cs:line 184}



DECLARE
p_price_list_hdr_id price_list_hdr.price_list_hdr_id%TYPE;
p_wht_tough_disc_amt price_list_hdr.wht_tough_disc_amt%TYPE;
p_wht_damp_disc_amt price_list_hdr.wht_damp_disc_amt%TYPE;
p_wht_stone_disc_amt price_list_hdr.wht_stone_disc_amt%TYPE;
p_durum_tough_disc_amt price_list_hdr.durum_tough_disc_amt%TYPE;
p_durum_damp_disc_amt price_list_hdr.durum_damp_disc_amt%TYPE;
p_durum_stone_disc_amt price_list_hdr.durum_stone_disc_amt%TYPE;
p_bly_tough_disc_amt price_list_hdr.bly_tough_disc_amt%TYPE;
p_bly_damp_disc_amt price_list_hdr.bly_damp_disc_amt%TYPE;
p_bly_stone_disc_amt price_list_hdr.bly_stone_disc_amt%TYPE;
p_desigtd_bly_tough_disc_amt price_list_hdr.desigtd_bly_tough_disc_amt%TYPE;
p_desigtd_bly_damp_disc_amt price_list_hdr.desigtd_bly_damp_disc_amt%TYPE;
p_price_list_status_type_name price_list_hdr.price_list_status_type_name%TYPE;
p_load_dtm price_list_hdr.load_dtm%TYPE;
p_user_name price_list_hdr.user_name%TYPE;
p_wht_indr_flag price_list_hdr.wht_indr_flag%TYPE;
p_durum_indr_flag price_list_hdr.durum_indr_flag%TYPE;
p_bly_indr_flag price_list_hdr.bly_indr_flag%TYPE;
p_desigtd_bly_indr_flag price_list_hdr.desigtd_bly_indr_flag%TYPE;
p_load_type_name price_list_hdr.load_type_name%TYPE;
p_wht_basis_num price_list_hdr.wht_basis_num%TYPE;
p_durum_basis_num price_list_hdr.durum_basis_num%TYPE;
p_bly_basis_num price_list_hdr.bly_basis_num%TYPE;
p_desigtd_bly_basis_num price_list_hdr.desigtd_bly_basis_num%TYPE;
p_src_file_path_desc price_list_hdr.src_file_path_desc%TYPE;
p_pool_part_code price_list_hdr.pool_part_code%TYPE;
p_sct_price_list_name price_list_hdr.sct_price_list_name%TYPE;
p_sct_effctv_dtm price_list_hdr.sct_effctv_dtm%TYPE;
p_row_cnt_qty price_list_hdr.row_cnt_qty%TYPE;
p_price_sum_amt price_list_hdr.price_sum_amt%TYPE;
BEGIN
p_price_list_hdr_id := '200804';
p_wht_tough_disc_amt := 8.00;
p_wht_damp_disc_amt := -11.50;
p_wht_stone_disc_amt := -5.00;
p_durum_tough_disc_amt := -7.00;
p_durum_damp_disc_amt := -10.50;
p_durum_stone_disc_amt := -4.00;
p_bly_tough_disc_amt := -6.00;
p_bly_damp_disc_amt := -9.50;
p_bly_stone_disc_amt := -3.00;
p_desigtd_bly_tough_disc_amt := -5.00;
p_desigtd_bly_damp_disc_amt := -8.50;
p_price_list_status_type_name := 'Initial';
p_load_dtm := '06/11/2008';
p_user_name := 'gxgervais';
p_wht_indr_flag := 'Y';
p_durum_indr_flag := 'Y';
p_bly_indr_flag := 'Y';
p_desigtd_bly_indr_flag := 'Y';
p_load_type_name := 'Initial';
p_wht_basis_num := 0;
p_durum_basis_num := 0;
p_bly_basis_num := 0;
p_desigtd_bly_basis_num := 0;
p_src_file_path_desc := 'C:\Backups\Test.xls';
p_pool_part_code := 'A';
p_sct_price_list_name := 'Initial Price List for Aug 2008 (test)';
p_sct_effctv_dtm := null;
p_row_cnt_qty := 0;
p_price_sum_amt := 0;
 
insert_price_list_hdr (
p_price_list_hdr_id,
p_wht_tough_disc_amt,
p_wht_damp_disc_amt,
p_wht_stone_disc_amt,
p_durum_tough_disc_amt,
p_durum_damp_disc_amt,
p_durum_stone_disc_amt,
p_bly_tough_disc_amt,
p_bly_damp_disc_amt,
p_bly_stone_disc_amt,
p_desigtd_bly_tough_disc_amt,
p_desigtd_bly_damp_disc_amt,
p_price_list_status_type_name,
p_load_dtm,
p_user_name,
p_wht_indr_flag,
p_durum_indr_flag,
p_bly_indr_flag,
p_desigtd_bly_indr_flag,
p_load_type_name,
p_wht_basis_num,
p_durum_basis_num,
p_bly_basis_num,
p_desigtd_bly_basis_num,
p_src_file_path_desc,
p_pool_part_code,
p_sct_price_list_name,
p_sct_effctv_dtm,
p_row_cnt_qty,
p_price_sum_amt
);
END;

Open in new window

0
 
mathieu_cuprykAuthor Commented:
here is error//
screen3.jpg
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.