mathieu_cupryk
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_REP ORTING.pri ce_list_de letions"; //schema.stored procedure
try
{
Database db = DatabaseFactory.CreateData base("Init ialPrices. Properties .Settings. Connection String");
DbCommand dbCommand = db.GetStoredProcCommand(pr ocedureNam e);
db.AddInParameter(dbComman d, "p_old_price_list_id", DbType.String, OldPriceList);
db.AddInParameter(dbComman d, "p_new_price_list_id", DbType.String, NewPriceList);
db.AddOutParameter(dbComma nd, "p_status", DbType.String, 255);
DataSet ds = new DataSet();
ds = db.ExecuteDataSet(dbComman d);
Status = dbCommand.Parameters[2].Va lue.ToStri ng();
return ds;
}
catch (Exception ex)
{
throw (ex);
}
ORA-06550: line 1, column 18:
PLS-00905: object INIT_PRICE.PRICE_LIST_REPO RTING is invalid
ORA-06550: line 1, column 7:
PL/SQL: Statement ignored
public DataSet ComparePriceListDelete(
string OldPriceList,
string NewPriceList,
ref string Status)
{
string procedureName = "init_price.PRICE_LIST_REP
try
{
Database db = DatabaseFactory.CreateData
DbCommand dbCommand = db.GetStoredProcCommand(pr
db.AddInParameter(dbComman
db.AddInParameter(dbComman
db.AddOutParameter(dbComma
DataSet ds = new DataSet();
ds = db.ExecuteDataSet(dbComman
Status = dbCommand.Parameters[2].Va
return ds;
}
catch (Exception ex)
{
throw (ex);
}
ORA-06550: line 1, column 18:
PLS-00905: object INIT_PRICE.PRICE_LIST_REPO
ORA-06550: line 1, column 7:
PL/SQL: Statement ignored
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'
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_REPO RTING.pric e_list_del etions object
1. To figure out under what account have you logged to Oracle
2. See if there is init_price.PRICE_LIST_REPO
ASKER
guys what is going on here is that it is blowing up because there is null being
return. How can I fix this.
return. How can I fix this.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
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?
ASKER
it is working however, i must build a status function in C#.
Host=ntsl2003a;Port=1521;S
See
http://www.datadirect.com/developer/net/daab/index.ssp