下面这个怎么错了??????
DECLARE VAR varchar2;
VAR := (SELECT COUNT(1) FROM TMDr01);
SELECT VAR;
下面这样创建存储过程对马? 我调用报错
create or replace procedure GET_DOCTORMST_NEW
(
v_delflg IN VARCHAR2,
v_withdata IN VARCHAR2,
v_columnList IN VARCHAR2,
RefCur_MasterBO OUT VARCHAR2,
v_totalCount OUT VARCHAR2);
)
as
begin
select F001,F002,F003,F004,F005,F006,F007,UPDID,UPDDT from tmdr01;
RefCur_MasterBO := '123';
v_totalCount := (select count(1) from tmdr01);
end调用方法
OracleCommand cmd = new OracleCommand("GET_DOCTORMST_NEW", con);
cmd.CommandType = CommandType.StoredProcedure;
#region 参数
OracleParameter v_delflg = new OracleParameter("v_delflg", OracleDbType.Varchar2);
v_delflg.Direction = ParameterDirection.Input;
cmd.Parameters.Add(v_delflg);
OracleParameter v_withdata = new OracleParameter("v_withdata",OracleDbType.Varchar2);
v_withdata.Direction = ParameterDirection.Input;
cmd.Parameters.Add(v_withdata);
OracleParameter v_columnList = new OracleParameter("v_columnList",OracleDbType.Varchar2);
v_columnList.Direction = ParameterDirection.Input;
cmd.Parameters.Add(v_columnList);
OracleParameter RefCur_MasterBO = new OracleParameter("RefCur_MasterBO",OracleDbType.Varchar2);
RefCur_MasterBO.Direction = ParameterDirection.Output;
cmd.Parameters.Add(RefCur_MasterBO);
OracleParameter v_totalCount = new OracleParameter("v_totalCount", OracleDbType.Varchar2);
v_totalCount.Direction = ParameterDirection.Output;
cmd.Parameters.Add(v_totalCount);
#endregion
try
{
string timeStart = DateTime.Now.ToString("yyyy-MM-dd HH:mm:ssss ffff"); //执行开始时间
OracleDataAdapter da = new OracleDataAdapter(cmd);
DECLARE VAR varchar2;
VAR := (SELECT COUNT(1) FROM TMDr01);
SELECT VAR;
下面这样创建存储过程对马? 我调用报错
create or replace procedure GET_DOCTORMST_NEW
(
v_delflg IN VARCHAR2,
v_withdata IN VARCHAR2,
v_columnList IN VARCHAR2,
RefCur_MasterBO OUT VARCHAR2,
v_totalCount OUT VARCHAR2);
)
as
begin
select F001,F002,F003,F004,F005,F006,F007,UPDID,UPDDT from tmdr01;
RefCur_MasterBO := '123';
v_totalCount := (select count(1) from tmdr01);
end调用方法
OracleCommand cmd = new OracleCommand("GET_DOCTORMST_NEW", con);
cmd.CommandType = CommandType.StoredProcedure;
#region 参数
OracleParameter v_delflg = new OracleParameter("v_delflg", OracleDbType.Varchar2);
v_delflg.Direction = ParameterDirection.Input;
cmd.Parameters.Add(v_delflg);
OracleParameter v_withdata = new OracleParameter("v_withdata",OracleDbType.Varchar2);
v_withdata.Direction = ParameterDirection.Input;
cmd.Parameters.Add(v_withdata);
OracleParameter v_columnList = new OracleParameter("v_columnList",OracleDbType.Varchar2);
v_columnList.Direction = ParameterDirection.Input;
cmd.Parameters.Add(v_columnList);
OracleParameter RefCur_MasterBO = new OracleParameter("RefCur_MasterBO",OracleDbType.Varchar2);
RefCur_MasterBO.Direction = ParameterDirection.Output;
cmd.Parameters.Add(RefCur_MasterBO);
OracleParameter v_totalCount = new OracleParameter("v_totalCount", OracleDbType.Varchar2);
v_totalCount.Direction = ParameterDirection.Output;
cmd.Parameters.Add(v_totalCount);
#endregion
try
{
string timeStart = DateTime.Now.ToString("yyyy-MM-dd HH:mm:ssss ffff"); //执行开始时间
OracleDataAdapter da = new OracleDataAdapter(cmd);
解决方案 »
- 用EnableFormSkins()后最大化变成满屏的难题
- DataTable数据分组问题
- sting 怎么转化时间类型datatime?
- vs2005bug--fileSystemWatcher为何执行两次?
- C++中的 inet_addr和inet_ntoa 在C#中有没有直接对应的函数?
- WinForm抓取网页数据的问题
- HttpWebRequest post传参
- 如何按次按时播放声音文件
- .NET 安装失败``请各位大虾帮个忙``谢谢了
- Winform treeView如何在指定的子节点添加节点?
- 下载文件问题 Response.OutputStream.Write
- 在线等!!!!!!!!!!着急!!!!!!!!!!
(
v_delflg IN VARCHAR2,
v_withdata IN VARCHAR2,
v_columnList IN VARCHAR2,
RefCur_MasterBO OUT VARCHAR2,
v_totalCount OUT VARCHAR2);//括号什么意思
)参考C#对Oracle存储过程的调用
as
begin
select F001,F002,F003,F004,F005,F006,F007,UPDID,UPDDT from tmdr01;
end;
我改成这样了还是有错误
报什么错