Use this query instead
select first_names || ' ' || last_name as user_name from cc_users where user_id = :user_id;