nvm, I see the problem, thanks!
oh wait, no, there was a problem, but that wasn't what was causing it
hmm, the inline query runs fine
SELECT * FROM t_user_media WHERE id in (SELECT user_media_id FROM t_playlist_content WHERE playlist_id = 115 ORDER by dbms_random.value);
this is the "correct" one