以下建立procedure的预防上有什么问题?create or replace procedure Test_Procedure_universe
AS
cursor c_getcursor(I in number)
is
SELECT *
FROM Test_Table where Test_Table.Id = I;
AS
cursor c_getcursor(I in number)
is
SELECT *
FROM Test_Table where Test_Table.Id = I;
create or replace procedure Test_Procedure_universe
AS
begin
cursor c_getcursor(I in number)
is
SELECT *
FROM Test_Table where Test_Table.Id = I;
end;
create or replace procedure Test_Procedure_universe
AS
cursor c_getcursor(I in number)
is
SELECT *
FROM Test_Table where Test_Table.Id = I;
begin
open c_getcursor;
fetch c_getcursor into I;
close c_getcursor;end Test_Procedure_universe;
--没有任何问题
create or replace procedure test
as
cursor c_getCursor(I in number)
is
SELECT *
FROM Test_Table where Test_Table.Id = I;begin
null;
end;
/