建的语句
CREATE OR REPLACE PROCEDURE msp_SM_INTERIM_T_Delete(pGBID VARCHAR2,pID VARCHAR2,pMID VARCHAR2,pReturnValue out NUMBER) AS
BEGIN
DELETE FROM SM_CHECK_RECORD_TEMP WHERE (GDBH_ID = pGBID);
DELETE FROM SM_GOODSBATCH_BASE_TEMP WHERE (ID = pGBID);
DELETE FROM SM_GOODS_INFO_TEMP WHERE (ID = pID);
DELETE FROM SM_MAKER_CERT_TEMP WHERE (MAKER_ID = pMID);
DELETE FROM SM_MAKER_BASE_INFO_TEMP WHERE (ID = pMID);
pReturnValue:=1;
EXCEPTION
WHEN OTHERS THEN
pReturnValue:=0;
RETURN;
END msp_SM_INTERIM_T_Delete;代码执行语句:public static int DeleteInterim(String GBID,String GID,String MID)
{
int ret;
using (DbAccess db = new DbAccess())
{
using (IDbCommand cmd = db.CreateProcCommand("SM_CHECK_RECORD_TEMP"))
{
DbAccess.AttachInParameter(cmd, "pGBID", DbType.String, GBID);
DbAccess.AttachInParameter(cmd, "pID", DbType.String, GID);
DbAccess.AttachInParameter(cmd, "pMID", DbType.String, MID);
DbAccess.AttachOutParameter(cmd, "pReturnValue", DbType.Int32, 4);
db.ExecuteNonQuery(cmd);
ret = Convert.ToInt32(((IDbDataParameter)cmd.Parameters[1]).Value);
}
}
return ret;
}
报错:
用户代码未处理
ORA-06550: 第 1 行, 第 7 列:
PLS-00221: 'SM_CHECK_RECORD_TEMP' 不是过程或尚未定义
ORA-06550: 第 1 行, 第 7 列:
PL/SQL: Statement ignored
CREATE OR REPLACE PROCEDURE msp_SM_INTERIM_T_Delete(pGBID VARCHAR2,pID VARCHAR2,pMID VARCHAR2,pReturnValue out NUMBER) AS
BEGIN
DELETE FROM SM_CHECK_RECORD_TEMP WHERE (GDBH_ID = pGBID);
DELETE FROM SM_GOODSBATCH_BASE_TEMP WHERE (ID = pGBID);
DELETE FROM SM_GOODS_INFO_TEMP WHERE (ID = pID);
DELETE FROM SM_MAKER_CERT_TEMP WHERE (MAKER_ID = pMID);
DELETE FROM SM_MAKER_BASE_INFO_TEMP WHERE (ID = pMID);
pReturnValue:=1;
EXCEPTION
WHEN OTHERS THEN
pReturnValue:=0;
RETURN;
END msp_SM_INTERIM_T_Delete;代码执行语句:public static int DeleteInterim(String GBID,String GID,String MID)
{
int ret;
using (DbAccess db = new DbAccess())
{
using (IDbCommand cmd = db.CreateProcCommand("SM_CHECK_RECORD_TEMP"))
{
DbAccess.AttachInParameter(cmd, "pGBID", DbType.String, GBID);
DbAccess.AttachInParameter(cmd, "pID", DbType.String, GID);
DbAccess.AttachInParameter(cmd, "pMID", DbType.String, MID);
DbAccess.AttachOutParameter(cmd, "pReturnValue", DbType.Int32, 4);
db.ExecuteNonQuery(cmd);
ret = Convert.ToInt32(((IDbDataParameter)cmd.Parameters[1]).Value);
}
}
return ret;
}
报错:
用户代码未处理
ORA-06550: 第 1 行, 第 7 列:
PLS-00221: 'SM_CHECK_RECORD_TEMP' 不是过程或尚未定义
ORA-06550: 第 1 行, 第 7 列:
PL/SQL: Statement ignored
解决方案 »
- asp页面中Checkbox是否选中结果传到下一页面并入库
- ASP.NET中,建立母版时,里面的编辑框怎么调大小和位置?
- asp.net
- 请问一下 用定位面板的问题 table or div 谢谢
- 请问asp.net2.0正式版最早什么时候公布? 我想学学2.0,不过还没买相应的有关书籍,想等2.0正式推出以后再买,各位认为怎么样?
- asp.net与存储过程
- 2005中新增了TreeView控件,怎么没有包括TabStrip WebControl
- 前后台传值取值的问题~~~~~~~~~~~~~~~
- ASP.NET中的网页设计器.用的是什么控件,或者技术,??
- 如何在Attribute中使用自定义属性
- IIS网站访问Report报表的问题
- Asp.net使用OraOLEDB.Oracle连接oracle问题
放在执行前