<?xml version="1.0" encoding="UTF-8"?>
<bm:model xmlns:bm="http://www.leaf-framework.org/schema/bm" needAccessControl="false">
<bm:operations>
<bm:operation name="update">
<bm:update-sql><![CDATA[
DECLARE
v_col_count NUMBER;
BEGIN
SELECT
COUNT(1)
INTO
v_col_count
FROM
con_collection_callback
WHERE
col_number = ${@col_number};
UPDATE
con_collection_callback t
SET
t.col_count = v_col_count
WHERE
t.callback_id = ${@callback_id};
END;
]]></bm:update-sql>
</bm:operation>
</bm:operations>
</bm:model>
-
Spencer Chang authoredbfd31bca