asp调用ORACLE过程的问题,我搞不定了,帮助看看
过程:CREATE OR REPLACE PROCEDURE LZ.JZCLDLZTJ (date_t1 in date,date_t2 in date)IS
.......
END;
ASP中:
check_dblike
sp_getproc
%>
<script language="vbscript" runat="server">
dim adocon,rs
sub check_dblike()
set adocon = server.createobject("adodb.connection")
adocon.open "Provider=OraOLEDB.Oracle;Data Source=hmis;User Id=lz;Password=lzjtw312"
end sub
sub sp_getproc()
dim strparms
strparms =cdate(request.from("x_MY_DATE1"))&","&cdate(request.from("x_MY_DATE2"))
set rs = adocon.execute("lz.jzcldlztj " &strparms)
end sub
</script>
哪里有问题?大家帮助看一下,很郁闷
