oracle8.1.6
begin
update acs_objects
set last_modified = sysdate,
modifying_user = :caller_id,
modifying_ip = :caller_ip
where object_id = :ticket_id;
update ttl_tickets
set name = :name,
message = :message,
message_format = :message_format
where ticket_id = :ticket_id;
end;