Sql代码 以DDL语句为参数。create procedure anyddl (s1 varchar2) ascursor1 integer;begincursor1 := dbms_sql.open_cursor;dbms_sql.parse(cursor1, s1, dbms_......
create or replace function updatecomm(p_comm emp.comm%type, p_empno emp.empno%type
return integer as
v_cid integer;
v_updatestr varchar2(100);
v_rowupdated integer;
begin
v_cid:=dbms_sql.open_cursor;
v_updatestr:='update emp set comm=:comm where empno=:empno';
dbms_sql.parse(v_cid,v_updatestr,dbms_sql.native);
dbms_sql.bind_variable(v_cid,'comm','p_comm');
dbms_sql.bind_variable(v_cid,'empno','p_empno');
v_rowupdated:=dbms_sql.execute(v_cid);
dbms_sql.close_cursor(v_cid);
return p_rowsupdated;
exception
when others then
dbms_sql.close_cursor(v_cid);
raise;
end
6/10 首页 上一页 4 5 6 7 8 9 下一页 尾页 |
