我实在是郁闷死了!!!
<!-- #include file = "adovbs.inc" -->
<%
set conn = server.createobject("adodb.connection")
strcon = "Provider=MSDAORA.1;Password=test;User ID=test;Data Source=test;Persist Security Info=True"
conn.open strcon
set rs = server.createobject("adodb.recordset")
set cmd = server.createobject("adodb.command")
cmd.ActiveConnection = conn
cmd.Parameters.Append cmd.CreateParameter(p_id, adInteger, adParamInput,2,1)
cmd.Parameters.Append cmd.CreateParameter(test_cursor,adVariant,adParamOutput)
cmd.CommandText = "pack001.testpack"
cmd.CommandType = adCmdStoredProc
cmd.CommandTimeout = 15
rs = cmd.Execute()
if rs.eof then
response.write "<br>Failed"
else
response.write "<br>OK"
end if
%>
create or replace package pack001
as
type my_cursor is ref cursor ;
procedure testpack (
p_id in number,
test_cursor out my_cursor
) ;
end pack001;
/
create or replace package body pack001 as
procedure testpack(
p_id in number,
test_cursor out my_cursor) as
begin
open test_cursor for
select * from test ;
end testpack;
end pack001;
存储过程在sqlplus李调用正常,可是早asp里报错:
ORA-01036: 非法的变量名/编号
可是我试过了所有的大小写都不行??错在哪儿呢?