L
lonanodo
Unregistered / Unconfirmed
GUEST, unregistred user!
create or replace package PK_DestoryDataQuery is<br> type My_Cursor is REF CURSOR;<br> procedure DestoryDataQuery(bz varchar2,Result_Data out My_Cursor);<br>end PK_DestoryDataQuery;<br><br>create or replace package body PK_DestoryDataQuery<br>is<br> procedure DestoryDataQuery(bz varchar2,Result_Data out My_Cursor)is<br> begin<br> open Result_Data for select count(*)s from shc_dzcYds_1 where bz=bz;<br> end DestoryDataQuery;<br>end PK_DestoryDataQuery<br><br>--调用<br> ADODataSet1.Close;<br> ADODataSet1.Parameters.Clear ;<br> ADODataSet1.CommandType :=cmdText;<br> ADODataSet1.CommandText :='{call PK_DestoryDataQuery.DestoryDataQuer(?)}';<br> ADODataSet1.Parameters.CreateParameter('bz',ftString,pdInput,50,'111');<br> ADODataSet1.Open;<br>ADODataSet1参数传不进oracle存储过程,有没有111都一样,请问是什么问题?