ls_sql="insert into "+tablename&
+"(id,MM) "&
+"values ("+string(ll_id)+",'"+ls_mm+"')"
execute immediate :ls_sql
using SQLCA;
if SQLCA.sqlcode<>0 then
ROLLBACK using SQLCA;
else
commit using SQLCA;
end if
删除
ROLLBACK using sqlca;
ls_sql="delete from"+tablename+" where id='"+string(ll_id)+"'"
execute immediate :ls_sql
using sqlca;
commit using sqlca;