procedure test(
ids in number,
o_OIID out cprivtool.toolid%type,
o_name out cprivtool.toolname%type
)
as
v_TARGETRec cprivtool%rowtype;
v_Dynamic varchar2(2048);
TYPE RefCurTyp IS REF CURSOR;
SceneCur RefCurTyp; --查询的动态游标
begin
v_Dynamic :='select * from tbprod_jnrwinfo where oiid='||ids;
OPEN SceneCur FOR v_Dynamic;
LOOP
FETCH SceneCur INTO v_TARGETRec;--v_SceneRec,v_ImageModeRec,v_centlong,v_centlat,v_StartTimeRec,v_EndTimeRec;
EXIT WHEN SceneCur%NOTFOUND;
o_OIID := v_TARGETRec.toolid;
o_name :=v_TARGETRec.toolname;
dbms_output.put_line(o_OIID);
dbms_output.put_line(o_name);
dbms_output.put_line(v_Dynamic);
end loop;
end test;怎么用asp.net把值返回到datagrid
ids in number,
o_OIID out cprivtool.toolid%type,
o_name out cprivtool.toolname%type
)
as
v_TARGETRec cprivtool%rowtype;
v_Dynamic varchar2(2048);
TYPE RefCurTyp IS REF CURSOR;
SceneCur RefCurTyp; --查询的动态游标
begin
v_Dynamic :='select * from tbprod_jnrwinfo where oiid='||ids;
OPEN SceneCur FOR v_Dynamic;
LOOP
FETCH SceneCur INTO v_TARGETRec;--v_SceneRec,v_ImageModeRec,v_centlong,v_centlat,v_StartTimeRec,v_EndTimeRec;
EXIT WHEN SceneCur%NOTFOUND;
o_OIID := v_TARGETRec.toolid;
o_name :=v_TARGETRec.toolname;
dbms_output.put_line(o_OIID);
dbms_output.put_line(o_name);
dbms_output.put_line(v_Dynamic);
end loop;
end test;怎么用asp.net把值返回到datagrid
procedure test(
ids in number,
o_OIID out cprivtool.toolid%type,
o_name out cprivtool.toolname%type
)
as
v_TARGETRec cprivtool%rowtype;
v_Dynamic varchar2(2048);
TYPE RefCurTyp IS REF CURSOR;
SceneCur RefCurTyp; --查询的动态游标
begin
v_Dynamic :='select * from cprivtool where oiid='||ids;
OPEN SceneCur FOR v_Dynamic;
LOOP
FETCH SceneCur INTO v_TARGETRec;--v_SceneRec,v_ImageModeRec,v_centlong,v_centlat,v_StartTimeRec,v_EndTimeRec;
EXIT WHEN SceneCur%NOTFOUND;
o_OIID := v_TARGETRec.toolid;
o_name :=v_TARGETRec.toolname;
dbms_output.put_line(o_OIID);
dbms_output.put_line(o_name);
dbms_output.put_line(v_Dynamic);
end loop;
end test;