postgresql7.4
SELECT cc_semester__new (NULL, :name, $start_date, $end_date,
:user_id, :peeraddr, :package_id)
UPDATE cc_semester
name = :name,
start_date = :start_date,
end_date = :end_date
WHERE semester_id = :semester_id
UPDATE acs_objects
SET modifying_user = :modifying_user,
modifying_ip = :modifying_ip
WHERE object_id = :semester_id