参考:
<%
dim cn,cmd,cmdrc,driver_name,para
driver_name="Provider=MSDAORA.1;Password=pass;User ID=user;Data Source=afis;Persist Security Info=True"
set cn = server.CreateObject("adodb.connection")
cn.open driver_name
set cmd=server.CreateObject("adodb.command")
set cmdrc=server.CreateObject("adodb.recordset")
cmd.CommandType = 1
set para = cmd.Parameters
'这个地方不要出错,一定要写myrc,不能是别的
cmd.CommandText = "{call tinger01.selectbudgettitle(?,{resultset 0, myrc})}"
'这个地方你的也有问题,asp是不认识adInteger,adParamInput的.
para.Append cmd.CreateParameter("p_depart_id",3,1,4,1)
'以下两句应当可以不要
cmdrc.CursorType = 3
cmdrc.LockType = 3
'设置连接
set cmd.ActiveConnection = cn
set cmdrc.Source = cmd
cmdrc.Open
'测试是否成功,我这里返回ok
if cmdrc.EOF then
response.Write "false"
else
response.Write "ok"
end if
%>
<%
dim cn,cmd,cmdrc,driver_name,para
driver_name="Provider=MSDAORA.1;Password=pass;User ID=user;Data Source=afis;Persist Security Info=True"
set cn = server.CreateObject("adodb.connection")
cn.open driver_name
set cmd=server.CreateObject("adodb.command")
set cmdrc=server.CreateObject("adodb.recordset")
cmd.CommandType = 1
set para = cmd.Parameters
'这个地方不要出错,一定要写myrc,不能是别的
cmd.CommandText = "{call tinger01.selectbudgettitle(?,{resultset 0, myrc})}"
'这个地方你的也有问题,asp是不认识adInteger,adParamInput的.
para.Append cmd.CreateParameter("p_depart_id",3,1,4,1)
'以下两句应当可以不要
cmdrc.CursorType = 3
cmdrc.LockType = 3
'设置连接
set cmd.ActiveConnection = cn
set cmdrc.Source = cmd
cmdrc.Open
'测试是否成功,我这里返回ok
if cmdrc.EOF then
response.Write "false"
else
response.Write "ok"
end if
%>
解决方案 »
- sql语句问题
- Oracle 10g怎么修改用户的身份
- oracle8热备份恢复问题大家帮忙看看,谢谢!
- 用proc写的程序不能用在多线程编程吗?
- 请问如何用sql语句将3行数据合并为1行数据?
- to_date的问题急
- 求助,如何将oracle的导出文件*.dmp,导到sqlserver中。。100分等着大家。。
- 求救,ORACLE断电后遇到的问题!!
- ORACLE管理工具(备份管理器具BACKUP MANAGER)???
- oracle 8i 用dbassist创建数据库报错,如何解决?
- (200高分)同一数据库中两个相同结构的表中数据的同步!!详见内容(在线急等!)
- proc 游标问题:如何判断一个游标的开关状态?
Set Rs = Server.CreateObject("ADODB.Recordset")
cmd.CommandType = 1
cmd.CommandTimeout = 0
cmd.Prepared = true
cmd.CommandText = "{call addInvoiceNo(?,?,?,?)}"cmd.Parameters.Append cmd.CreateParameter("p_invSet_id",3, 1,3,setid)
cmd.Parameters.Append cmd.CreateParameter("p_invType_id",3, 1,3,invoice_type_id)
cmd.Parameters.Append cmd.CreateParameter("p_minno",200, 1,200,minno)
cmd.Parameters.Append cmd.CreateParameter("p_maxno",200, 1,200,maxno)set rs.Source = CMD
on error resume next
set rs=CMD.Execute
if err.number <> 0 then
response.Write err.Description
response.End
end if
rs.Open()
//---- DataTypeEnum Values ----
var adEmpty = 0;
var adTinyInt = 16;
var adSmallInt = 2;
var adInteger = 3;
var adBigInt = 20;
var adUnsignedTinyInt = 17;
var adUnsignedSmallInt = 18;
var adUnsignedInt = 19;
var adUnsignedBigInt = 21;
var adSingle = 4;
var adDouble = 5;
var adCurrency = 6;
var adDecimal = 14;
var adNumeric = 131;
var adBoolean = 11;
var adError = 10;
var adUserDefined = 132;
var adVariant = 12;
var adIDispatch = 9;
var adIUnknown = 13;
var adGUID = 72;
var adDate = 7;
var adDBDate = 133;
var adDBTime = 134;
var adDBTimeStamp = 135;
var adBSTR = 8;
var adChar = 129;
var adVarChar = 200;
var adLongVarChar = 201;
var adWChar = 130;
var adVarWChar = 202;
var adLongVarWChar = 203;
var adBinary = 128;
var adVarBinary = 204;
var adLongVarBinary = 205;
var adChapter = 136;
var adFileTime = 64;
var adDBFileTime = 137;
var adPropVariant = 138;
var adVarNumeric = 139;以下是一些输入输出参数:
//---- ParameterDirectionEnum Values ----
var adParamUnknown = 0x0000;
var adParamInput = 0x0001;
var adParamOutput = 0x0002;
var adParamInputOutput = 0x0003;
var adParamReturnValue = 0x0004;以下是一些命令参数对照表
//---- CommandTypeEnum Values ----
var adCmdUnknown = 0x0008;
var adCmdText = 0x0001;
var adCmdTable = 0x0002;
var adCmdStoredProc = 0x0004;
var adCmdFile = 0x0100;
var adCmdTableDirect = 0x0200;