W
wxj810256
Unregistered / Unconfirmed
GUEST, unregistred user!
ORACLE存储过程返回的记录集是只读的吗?
我有以下存储过程:
create or replace package aaa1 is
type Empaa is REF CURSOR;
procedure open_emp(ia in char,emp OUT Empaa);
end aaa1;
create or replace package body aaa1 As
procedure open_emp (ia in char,emp OUT Empaa)
IS
BEGIN
OPEN emp FOR SELECT qyjb.rowid,QYJB.* FROM qyjb where dw=ia;
END open_emp;
end aaa1;
用ODAC的OraStoredProc控件读取记录后无法编辑,
ORACLE的存储过程返回的记录集都是只读的?
如何得到可编辑的记录集?
我有以下存储过程:
create or replace package aaa1 is
type Empaa is REF CURSOR;
procedure open_emp(ia in char,emp OUT Empaa);
end aaa1;
create or replace package body aaa1 As
procedure open_emp (ia in char,emp OUT Empaa)
IS
BEGIN
OPEN emp FOR SELECT qyjb.rowid,QYJB.* FROM qyjb where dw=ia;
END open_emp;
end aaa1;
用ODAC的OraStoredProc控件读取记录后无法编辑,
ORACLE的存储过程返回的记录集都是只读的?
如何得到可编辑的记录集?