插入insert:
--------------------------------------------------------------------------------------------------------------
DECLARE
resnum number;BEGIN
apex_plugin_util.print_json_http_header;
insert into customer_right (cust_code) values (:val);
resnum := SQL%ROWCOUNT;
sys.htp.p('{' ||
apex_javascript.add_attribute('success', 'true', false, true) ||
apex_javascript.add_attribute('rowcount', resnum, false, true) ||
apex_javascript.add_attribute('sqlcode', SQLCODE, false, true) ||
apex_javascript.add_attribute('sqlerrm', SQLERRM, false, false) || '}');
EXCEPTION
WHEN OTHERS THEN
rollback;
sys.htp.p('{' || apex_javascript.add_attribute('success',
'false',
false,
true) ||
apex_javascript.add_attribute('rowcount',
resnum,
false,
true) ||
apex_javascript.add_attribute('sqlcode',
SQLCODE,
false,
true) ||
apex_javascript.add_attribute('sqlerrm',
SQLERRM,
false,
false) || '}');
END;
----------------------------------------------------------------------------------------
更新(update):
----------------------------------------------------------------------------------------
DECLARE
resnum number;
BEGIN
apex_plugin_util.print_json_http_header;
update customer_right set cust_code = :val where cust_code = :key;
resnum := SQL%ROWCOUNT;
sys.htp.p('{' ||
apex_javascript.add_attribute('success', 'true', false, true) ||
apex_javascript.add_attribute('rowcount', resnum, false, true) ||
apex_javascript.add_attribute('sqlcode', SQLCODE, false, true) ||
apex_javascript.add_attribute('sqlerrm', SQLERRM, false, false) || '}');
EXCEPTION
WHEN OTHERS THEN
rollback;
sys.htp.p('{' || apex_javascript.add_attribute('success',
'false',
false,
true) ||
apex_javascript.add_attribute('rowcount',
resnum,
false,
true) ||
apex_javascript.add_attribute('sqlcode',
SQLCODE,
false,
true) ||
apex_javascript.add_attribute('sqlerrm',
SQLERRM,
false,
false) || '}');
END;
-----------------------------------------------------------------------------------------
删除(delete):
-----------------------------------------------------------------------------------------
DECLARE
resnum number;
BEGIN
apex_plugin_util.print_json_http_header;
delete from customer_right where cust_code = :key;
resnum := SQL%ROWCOUNT;
sys.htp.p('{' ||
apex_javascript.add_attribute('success', 'true', false, true) ||
apex_javascript.add_attribute('rowcount', resnum, false, true) ||
apex_javascript.add_attribute('sqlcode', SQLCODE, false, true) ||
apex_javascript.add_attribute('sqlerrm', SQLERRM, false, false) || '}');
EXCEPTION
WHEN OTHERS THEN
rollback;
sys.htp.p('{' || apex_javascript.add_attribute('success',
'false',
false,
true) ||
apex_javascript.add_attribute('rowcount',
resnum,
false,
true) ||
apex_javascript.add_attribute('sqlcode',
SQLCODE,
false,
true) ||
apex_javascript.add_attribute('sqlerrm',
SQLERRM,
false,
false) || '}');
END;