在线等!!!!!!!!!!着急!!!!!!!!!!
我创建一个存储过程,,下面2句话 有问题,,, 请问哪里错了阿create or replace procedure test(v_delflg in varchar2, v_withdata in varchar2, v_columnList in varchar2, RefCur_MasterBO out varchar2,v_totalCount out varchar2) is
begin
--SELECT F001,F002,F003,F004,F005,F006,F007,UPDID,UPDDT FROM TMDR01; RefCur_MasterBO := '1';
--v_totalCount := (select count(*) from TMDR01);
end test;
--------------------编程问答-------------------- v_totalCount := (select count(*) from TMDR01);
oracle貌似是
select count(*) into v_totalCount from TMDR01
吧 --------------------编程问答-------------------- 这不像是SQL Server中的存储过程啊 --------------------编程问答-------------------- oracle的存储过程语法,自己看看 --------------------编程问答-------------------- 不会是把oracle的贴到sqlserver了吧 --------------------编程问答--------------------
--------------------编程问答-------------------- create or replace procedure test(v_delflg in varchar2,
v_withdata in varchar2,
v_columnList in varchar2,
RefCur_MasterBO out varchar2,
v_totalCount out varchar2) as
begin
SELECT F001,F002,F003,F004,F005,F006,F007,UPDID,UPDDT FROM TMDR01; RefCur_MasterBO := '1';
v_totalCount := select count(*) from TMDR01;
end test;
--------------------编程问答-------------------- 有人会没有啊???????????没有人会ORACLE阿?
补充:.NET技术 , C#