Link to home
Start Free TrialLog in
Avatar of mathieu_cupryk
mathieu_cuprykFlag for Canada

asked on

DAAB error System.Data.OracleClient.OracleException: ORA-06550

[WebMethod(Description = "Compare PriceList")]
        public DataSet ComparePriceListDelete(
            string OldPriceList,
            string NewPriceList,
            ref string Status)
        {
            string procedureName = "init_price.PRICE_LIST_REPORTING.price_list_deletions"; //schema.stored procedure
            try
            {
                Database db = DatabaseFactory.CreateDatabase("InitialPrices.Properties.Settings.ConnectionString");
                DbCommand dbCommand = db.GetStoredProcCommand(procedureName);
                db.AddInParameter(dbCommand, "p_old_price_list_id", DbType.String, OldPriceList);
                db.AddInParameter(dbCommand, "p_new_price_list_id", DbType.String, NewPriceList);
               
                db.AddOutParameter(dbCommand, "p_status", DbType.String, 255);
                DataSet ds = new DataSet();

                ds = db.ExecuteDataSet(dbCommand);
                Status = dbCommand.Parameters[2].Value.ToString();
               
                return ds;
            }
            catch (Exception ex)
            {
                throw (ex);
            }
ORA-06550: line 1, column 18:
PLS-00905: object INIT_PRICE.PRICE_LIST_REPORTING is invalid
ORA-06550: line 1, column 7:
PL/SQL: Statement ignored
Avatar of schwertner
schwertner
Flag of Antarctica image

Have you established connection using parameters like:

Host=ntsl2003a;Port=1521;SID=ORCL1252

See
http://www.datadirect.com/developer/net/daab/index.ssp
looks like the PRICE_LIST_REPORTING object is invalid

Could try the following query:
select status from all_objects where object_name = 'PRICE_LIST_REPORTING'
You have:
1. To figure out under what account have you logged to Oracle
2. See if there is  init_price.PRICE_LIST_REPORTING.price_list_deletions object

Avatar of mathieu_cupryk

ASKER

guys what is going on here is that it is blowing up because there is null being
return. How can I fix this.

ASKER CERTIFIED SOLUTION
Avatar of Dauhee
Dauhee
Flag of Ireland image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
i am not sure where it is going wrong then
Hi mathieu_cupryk thats for accepting my proposal. Is it still not working for you though?
it is working however, i must build a status function in C#.