oradatabase.dbexecutesql("begin totledeptsalary(:inputvalue,:outputbalue,outputvalue2)end;")
解决方案 »
- alter user 两次改变用户表空间后的状况
- 用sqlplus能不能插入blob,clob,long raw和bfile等数据类型的值
- 求一监控脚本!希望大家共享下~
- oracle10g能否在Enterprise Manager里设置归档模式
- 由列变行排序问题
- OCIW32.DLL文件的处理
- ===申请增加扩充话题版块大签名!!!===
- 备份与恢复问题,请高手指点
- 急盼高手赐教:oracle存储过程返回的结果是否可以批处理??
- 怎么产生数据库的sql角本?
- 求 :最快的速度把一个表中的相关记录给删除?
- 在一表中有一日期型字段,有数百条记录,日期格式为2004-4-10 12:20:19形式,怎么写SQL把日期改成2004-4-10形式
<% '连接数据库
set OraSession=CreateObject("OracleInProcServer.XOraSession")
set OraDatabase=OraSession.DbOpenDatabase("mydb","bookshop/1234",0)
OraDatabase.Parameters.Add "num1",10,1
OraDatabase.Parameters("num1").ServerType=2
OraDatabase.Parameters.Add "num2",10,1
OraDatabase.Parameters("num2").ServerType=2
OraDatabase.Parameters.Add "result",0,2
OraDatabase.Parameters("result").ServerType=2
OraDatabase.DbExecuteSQL("Begin :result:=ADD1(:num1,:num2);end;")
response.Write(OraDatabase.Parameters("result").value)
%>
create or replace package ceshiname is
-- Created : 2004-4-19 11:13:19
type mytype is ref cursor;
-- Public function and procedure declarations
procedure getname(r_cursor OUT mytype);
end ceshiname;create or replace package body ceshiname is -- Function and procedure implementations
procedure getname(r_cursor out mytype) is
strsql varchar2(500);
begin
strsql:='select ceshi.name from ceshi';
OPEN r_cursor FOR strsql;
end;
end ceshiname;在asp中调用:
Set Conn=Server.CreateObject("ADODB.Connection")
Set CMD=Server.CreateObject("ADODB.Command")
Set rs = Server.CreateObject("ADODB.Recordset")
connstr="Dsn=sdit;UID=sa;PWD=sa;Server=svr"
conn.Open connstr
CMD.ActiveConnection = conn
CMD.CommandType = 1
CMD.CommandTimeout = 0
CMD.Prepared = trueCMD.CommandText = "{call ceshiname.getname()}"
set rs.Source = CMD
set rs = CMD.Execute
rs.Open()
Do While not rs.eof
Response.write(rs.Fields(0).value & ";")
rs.movenext
loop
rs.close
set rs=nothing